Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
I am looking for the solution to write data from Dataflow to Azure Sql Server database. Please help me with this.
I have mutiple workspace and from each workspace few datamodel want to write back to SQL server.
Thanks,
Vijai
Hi @mauryavijai ,
Has your problem been solved? If it is solved, you can mark the answer.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @mauryavijai ,
give it a try, hope that works for you 👍! I would be happy if you could give me an update as I only once brought my own data lake.
Also I would be happy if you can mark my post as solution. That helps the next person with a similar issue to find a solution easier.
Best regards
Denis
Sure, Let me implement and then mark it as solution.
Hi @mauryavijai
This might help you
https://bielite.com/blog/write-back-to-sql-database-from-power-bi/
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hey @mauryavijai ,
before you set up the dataflow you can connect it to an existing Azure Data Lake Gen 2 (Bring your own data lake):
Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Docs
Then you can use your Data Lake with other tools, for example use Azure Data Factory to load the data from the data lake and write it to an Azure SQL Server database.
I think with Power Apps it could also be possible, but I didn't test that.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.