Forum Discussion
Exporting data from Power BI to Excel
The export to CSV is there, you click the ellipses (...) on a visual and choose "Export". The only option you have for export is CSV. For anything beyond that, you'll have to post a new Idea.
Currently we have the export to csv or excel using the UI. If there is an api to do it programmatically, please let me know.
No, there is no way to do this. The Power BI REST API lets you push new data to a data set, or pull metadata, but not the raw underlying data. The export option (under the "..." menu for a visual) will export the data as the visual displays it, so if you visual aggregates the data in some way, the export will similarly be aggregated. Lastly, analyze in excel allows you to connect to the data model in Power BI service, but you are working with a power pivot data model and not the underlying data, and you need to explicitly create measures in Power BI in order to drop them into your values section of the pivot table.
