Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
These two videos, from same author, illustrate how you can write back your data in SQL Server from PQ
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.
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.
These two videos, from same author, illustrate how you can write back your data in SQL Server from PQ
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |