Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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:
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.
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.
You can do this with Power Update from poweron solutions