topic Re: Write data from Dataflow Data model to Azure SQL Server database in Service

Write data from Dataflow Data model to Azure SQL Server database

mauryavijai — Thu, 27 May 2021 12:40:03 GMT

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

Re: Write data from Dataflow Data model to Azure SQL Server database

selimovd — Thu, 27 May 2021 13:02:01 GMT

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.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

Re: Write data from Dataflow Data model to Azure SQL Server database

aj1973 — Thu, 27 May 2021 13:02:20 GMT

Hi mauryavijai

This might help you

https://bielite.com/blog/write-back-to-sql-database-from-power-bi/

Re: Write data from Dataflow Data model to Azure SQL Server database

mauryavijai — Thu, 27 May 2021 18:44:41 GMT

Thanks selimovd and aj1973 for your quick response.

I have already used the suggestion given by aj1973 but not sure if that work after published to BI.

I will implement the suggesition given by selimovd seems more better way to hadle it.

Re: Write data from Dataflow Data model to Azure SQL Server database

selimovd — Thu, 27 May 2021 21:11:12 GMT

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

Re: Write data from Dataflow Data model to Azure SQL Server database

mauryavijai — Sun, 30 May 2021 13:52:44 GMT

Sure, Let me implement and then mark it as solution.

Re: Write data from Dataflow Data model to Azure SQL Server database

Anonymous — Tue, 08 Jun 2021 02:03:56 GMT

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.