how to load the power bi dataset/ table data from power bi to SQL Server using Power Automate

[Anonymous]

how to load the power bi dataset/ table data from power bi to SQL Server using Power Automate?

I have a table visual in power bi report, I have to load table data into sql server using Power Automate?

Please help me on this asap....

[Anonymous · Accepted solution]

Hi @Anonymous ,

To export data from power query to sql server, it is possible and have multiple ways that you can try:

1. Using R script, please refer:

• Export data from Power Query to Local Machine or SQL Server using R scripts 

2. Using SSIS or R script, please refer:

• Exporting Power BI Data to SQL Server 

3. Ohter ways like json, please refer:

• Exporting Power Query tables to SQL Server 

All of these articles and blogs introduce it in details, hope to help you.

Best Regards,

Jay