Forum Discussion
New User - Power Query export to SQL Server
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:
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.
Super UserPower BI is a reporting tool. Think of it as a one way street (sadly). Power Query smells like an ETL tool but it's a juvenile version.
Having said that - you can run native queries against SQL data sources, including INSERT and UPDATE statements etc. in Power Query. But do you really want to do that?
Maybe look into a proper ETL tool for your big transforms, one that has error handling and auditing.