Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 workaround.
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.
@bcdobbs Can you please elaborate step wise on the second solution
I really want to try that out
It's not somethign I've ever done myself but my understanding is...
1) You need an azure subscription (pay as go is a good place to kick off!)
2) Spin up a storage account following instructions in:
Create a storage account for Azure Data Lake Storage Gen2 | Microsoft Docs
3) Configure Power Bi to use your azure storage account for data flows:
Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Docs
At that point if you connect to the storage account you should be able to see any results from data flows stored in a csv like format (never seen it myself!)