cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
klehar
Helper IV
Helper IV

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 workaround.

3 REPLIES 3
bcdobbs
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors