Forum Discussion
Sending data form power bi dataflow to sql server
Hi, For one of my use cases, I wanted to send the data from a few tables that reside in my dataflow to sql server. I wanted to know if this is possible through some script or any other workaroun...
You can make use of a native query in power query: Write Back to SQL Database from Power BI - BI Elite
Alternatively if you bring your own data lake Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Docs the results of the data flow are then accessible and you could connect and read into SQL with a variety of methods.
