Export data from Power BI table visual to Azure SQLtable

[v-agutta]

I need to get data from Power BI visuals into Azure SQL tables. Could anyone help me on this..?

[Anonymous · Accepted solution]

Hi @v-agutta ,

Sorry to reply to you so late. There are two links below which explain in detail how to export Power BI data to SQL Server. The first video link uses the R script method, and the second blog describes two methods: R script and using SSIS (but this is for On premises SQL Server). If you are not familiar with R, you can check the Requirements part in second link, which mentions the installation and setup of R and the installation of RODBC library. You can refer to both of these links to achieve your needs.

• How to export data from Power BI/Query to Azure SQL
• Exporting Power BI Data to SQL Server

Best Regards

[amitchandak]

@v-agutta , Power Automate or Rest API should help

rest API - https://docs.microsoft.com/en-us/rest/api/power-bi/reports/export-report

Python - https://sqlitybi.com/how-to-auto-schedule-data-export-from-power-with-pythn/

You need try code for DB

[v-agutta]

@amitchandak Thanks for your help, I m not able to open the python link which u provided. Could u please help on this?