Forum Discussion
Export data from Power BI table visual to Azure SQLtable
I need to get data from Power BI visuals into Azure SQL tables. Could anyone help me on this..?
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.
Best Regards
3 Replies
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
amitchandak Thanks for your help, I m not able to open the python link which u provided. Could u please help on this?
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.
Best Regards
