Push Power Query result in a database

[AGo]

Is there a way to schedule the extraction data from multiple datasources with power query and push the resulting table in a SQL Server or other databases? I think Power BI Gateway has the engine to do this.

Then I'll only need to make a select all to push data in Service side.

A lot of customers are complaining because they want also to access their shaped data with sql and not only with Power BI Visuals.

Many thanks

[v-yingjl · Accepted solution]

Hi @AGo ,

Currently it is possible to extract data from power query to sql server 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,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattAllington]

You can do this with Power Update from poweron solutions