Cleansed data to SQL Server

[TerriblyVexed]

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

[v-angzheng-msft · Accepted 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.

[amitchandak]

@TerriblyVexed , Power Automate, and Power BI rest APIs can help