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

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors