Forum Discussion
Exporting data from report in Power BI service to Azure SQL table
Hi all, i want to export the data from the report in Power Bi service or from a dataset in PowerBI service to a Azure SQL table. Is this can happen? If so could anyone please guide me how to do this? Thanks in advance!!!
2 Replies
- FowmySuper User
v-agutta
You can connect to the dataset from a Power BI desktop using Power BI Dataset Connector and use DAX Studio to export the data ( send the data) to SQL.
Please refer to: https://www.youtube.com/watch?v=WaUCYUHLHdw - v-luwang-msftCommunity Support
Hi v-agutta ,
The following article tells how to use R to export Exporting data from report in Power BI service to SQL .You need to do the fllowing prepare first.
1,Publish the existing Power BI Desktop solution to Power BI Service
2.Install On-premises Data Gateway in PERSONAL MODETo learn more details ,refer:
Export Power BI Service Data to SQL Server
Did I answer your question? Mark my post as a solution!
Best RegardsLucien