how load data to SQL database from power query

[Rahul_SC]

Hi all,

I have a raw table where I apply transformation steps using power query. The end output, I want to load data directly to SQL database not in my excel file. The need is everytime when raw data is updated then the end output should go into database and store the data.

how to build this connection ?

[Vijay_A_Verma · Accepted solution]

These two videos, from same author, illustrate how you can write back your data in SQL Server from PQ

https://www.youtube.com/watch?v=UFD5S4Peqc4

https://www.youtube.com/watch?v=WgIhsF7kEjI 

[Rahul_SC]

@Vijay_A_Verma  this helps. thanks!

@v-jingzhang, thanks for the links, learnt new things. 

[v-jingzhang · Accepted solution]

Hi @Rahul_SC 

If you want to export data from Power BI Desktop into a SQL Server database manually, you can use DAX Studio. After you install it, it will appear in your Power BI Desktop as an external tool.  

If you want to export data automatically after transformation, you can try Python or R methods as below. Publish the pbix file to Power BI service and set a scheduled refresh for this dataset. To use Python or R, it requires the personal-mode on-premises data gateway. 

Exporting Power BI Desktop data to SQL Server using Python | Sandeep Pawar | PawarBI.com 

Exporting Power BI Data to SQL Server 

And this video may also be helpful: 

Export Filtered Dataset from Power BI to SQL Server Programmatically using API and Power BI Embedded 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Vijay_A_Verma · Accepted solution]

These two videos, from same author, illustrate how you can write back your data in SQL Server from PQ

https://www.youtube.com/watch?v=UFD5S4Peqc4

https://www.youtube.com/watch?v=WgIhsF7kEjI