Get data from DataFlow programatically

[FelipeCosta]

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?

[FelipeCosta]

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]

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

[DavisBI]

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