New User - Power Query export to SQL Server

[pkoel-asb]

Hello,

  I am a very new Power Query use in Power BI. I have had to do a tremendous amount of transforming for one of my Power BI dekstop apps. From within Power Query, is it possible to export the table, with all of the transforms attached/applied, to SQL server? I would then be able to pull it into other Power Bi reports as a data source. I know, I can copy/paste the tables from one Power BI app to another, but all the tables seems to be a lot of clutter. 

Cheers,

Peter

[FERAY]

Bonjour,J’ai le même type de besoin : nombreuses sources de données hétérogènes (multi-logiciels), souhait de transformation (ETL) pour les faire converger, via un rafraîchissement automatique programmé, dans une BDD SQLSERVER, modèle de données « universel » , permettant de maintenir des rapports Power BI génériques,
s’appuyant sur cette BDD SQL unique.

Quel.s ETL utiliser, POWERQUERY, autres ?
Merci para avance, de vos pistes et suggestions

[lbendlin]

Use SSIS.

[v-yingjl · Accepted solution]

Hi @pkoel-asb ,

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:

• 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.

[lbendlin]

Power 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.