Forum Discussion
Cleansed data to SQL Server
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
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.
2 Replies
TerriblyVexed , Power Automate, and Power BI rest APIs can help
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.
