Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
User | Count |
---|---|
48 | |
28 | |
21 | |
19 | |
19 |
User | Count |
---|---|
51 | |
47 | |
25 | |
23 | |
20 |