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...
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!)