Sending data form power bi dataflow to sql server

[klehar]

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.

[bcdobbs]

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.

[klehar]

@bcdobbs Can you please elaborate step wise on the second solution

I really want to try that out

[bcdobbs]

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