New Export to Excel Format in Power BI

We have been waiting for this feature to be delivered for a while. Until this week, the only way to export data from Power BI was to do it into a source data table.

That meant that if you had data laid out like shown below, and you exported it to Excel

It would end up looking like this.

There are some benefits of this data format, but many people were frustrated by this.

Microsoft has now released an updated Export to Excel experience in the Power BI Service.  You will now be given a choice of 3 options (although I could only get 2 of them to work).

Author: Matt Allington

Read more at: Excelerator BI