Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
This may a dumb question but is there any way to use Power BI as a loading mechanism? If I have my data and I have made transformations and whatnot can I then store these data into a relational database? I'm using SQL Server.
I know the more common thing is to pull data from SQL Server but, in this instance, temporarily, I need to store it out to SQL Server.
I'm sorry if this is daft and I do feel like I've missed something very basic in my Power BI learning. But nonetheless here I am.
TIA
Vexed
Solved! Go to Solution.
Hi, @TerriblyVexed
Based on my research, you can use R script, SSIS, DAX Studio, web API, etc. to extract data from Power BI to SQL server.
1. DAX Studio
For reference:
https://alphavima.com/exporting-data-from-power-bi-pbix-file-to-sql-server/
2. R script, SSIS
For reference:
https://www.biinsight.com/exporting-power-bi-data-to-sql-server/
3. web API
For reference:
https://bielite.com/blog/write-back-to-sql-database-from-power-bi/
4. The relevant
https://www.youtube.com/watch?v=aHcDQT3n6BY
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @TerriblyVexed
Based on my research, you can use R script, SSIS, DAX Studio, web API, etc. to extract data from Power BI to SQL server.
1. DAX Studio
For reference:
https://alphavima.com/exporting-data-from-power-bi-pbix-file-to-sql-server/
2. R script, SSIS
For reference:
https://www.biinsight.com/exporting-power-bi-data-to-sql-server/
3. web API
For reference:
https://bielite.com/blog/write-back-to-sql-database-from-power-bi/
4. The relevant
https://www.youtube.com/watch?v=aHcDQT3n6BY
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 51 | |
| 37 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 70 | |
| 64 | |
| 39 | |
| 33 | |
| 23 |