topic Re: Get data from DataFlow programatically in Developer

Get data from DataFlow programatically

FelipeCosta — Fri, 18 Feb 2022 16:40:13 GMT

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?

Re: Get data from DataFlow programatically

DavisBI — Sat, 19 Feb 2022 16:27:14 GMT

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

Re: Get data from DataFlow programatically

bcdobbs — Sun, 20 Feb 2022 19:12:40 GMT

@FelipeCostaHave you seen this:

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

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.

Re: Get data from DataFlow programatically

FelipeCosta — Sun, 20 Feb 2022 22:45:09 GMT

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.