Forum Discussion
Exporting data from Power BI to Excel
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.