Silently an update to the Power BI service was deployed which included a highly demanded feature: Data Export (and that’s what it is – just data!).
If you open a PowerBI report and hover over the “more” menu you get a new menu-item for exporting data. As far as I found out today this export option works for either tables, charts and also maps –> but be aware: only the data is exported no charts! (as of today, but who knows, with the speed of #PowerBI development when we get this export method).
Shortly after starting the export action a dialog is displayed that let’s you choose what you want to do with the generated CSV file. If you use Firefox (with Excel installed on the same machine) an open dialog is displayed; chrome just downloads the generated CSV file.
In Excel, you can use the built-in data formating actions to split data into columns and format your data.
A quick overview diagram:
Happy Power BI testing!