Forum Discussion
Post PatronPush Power Query result in a database
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
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:
2. Using SSIS or R script, please refer:
3. Ohter ways like json, please refer:
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.
2 Replies
- MattAllington
Community Champion
You can do this with Power Update from poweron solutions
v-yingjlCommunity Support
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:
2. Using SSIS or R script, please refer:
3. Ohter ways like json, please refer:
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.
