Forum Discussion
AGo
Post Patron
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 d...
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.
MattAllington
Community Champion
Community ChampionYou can do this with Power Update from poweron solutions