Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
FelipeCosta
Advocate I
Advocate I

Get data from DataFlow programatically

Hello,

 

The compay I'm working for has Power BI Premium subscription.

Currently, I can use AdomdConnection to consume Dataset data programatically (C#).

I'd like to know how to consume Dataflow's query data programatically. I know that Dataflows are stored in storage accounts, but so far I couldn't write any code.

Could you help?

3 REPLIES 3
FelipeCosta
Advocate I
Advocate I

Thanks @bcdobbs , I managed to create a storage account and then use it as dataflow's storage.

 

There is another trick that maybe I'll stick with, without switching the storage account:

-Open Power BI Desktop with a file in import mode with a Dataflow

-Open Fiddler Classic program (it monitors http requests sent from computer).

-Open Power Query and refresh dataflow.

 

This way I can get, from Fiddler, the URL the dataflow is. I tried it and so far, it has worked. I fear the URL being temporary and the the URL gets invalid (revoked) with few days, I have to confirm if this can be a long term solution.

bcdobbs
Super User
Super User

@FelipeCostaHave you seen this:

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-azure-data-lake-storag...

Dataflow data would be stored in a storage account as you say but if you "bring your own" you then have direct access to it.



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!!
DavisBI
Solution Specialist
Solution Specialist

@FelipeCosta  Hi, currently no API for query Dataflow's data. You can try to transfer the data to Power BI dataset first

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors