Forum Discussion

klehar's avatar
klehar
Icon for Helper V rankHelper V
4 years ago

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...
Need Help
klehar's avatar
klehar
Icon for Helper V rankHelper V
4 years ago

bcdobbs Can you please elaborate step wise on the second solution

I really want to try that out

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

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