export data from power bi workspace

Anonymous  if your dataset is hosted in a premium workspace ... then it is possible to connect to the dataset using SQL Server Management Studio (please refer to this link https://docs.microsoft.com/en-us/power-bi/service-premium-connect-tools). With that being said, it is possible to programmatically access your data just like how you connect to SSAS (for example, using AdomdClient in C#).

Another option for you to get data from the Power BI Service (though I have never tried before) would be using Power BI publisher for Excel to connect to Power BI data in Excel (please refer to this link https://docs.microsoft.com/en-us/power-bi/publisher-for-excel)

Hope this helps.

Hi Anonymous  

 An option for you to get data from the Power BI Service would be using “export data”, but currently it is only supported for a single visual or a tile, it ‘s not supported for millions of records from multiple datasets or others.

For the details, you can turn to the URL as below: https://community.powerbi.com/t5/Desktop/export-data-from-power-bi-workspace/td-p/883826

Another option would be using “analyze in Excel”, where you can export the  data of the whole report or datasets as an excel file.

For the details, you can turn to the URL as below: https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

Hope this would help.

Best Regards,

Kelly