Exporting data from report in Power BI service to Azure SQL table

[v-agutta]

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!!!

[v-luwang-msft]

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 MODE

To learn more details ,refer:

Export Power BI Service Data to SQL Server

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[Fowmy]

@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