Forum Discussion
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
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.
FelipeCosta Hi, currently no API for query Dataflow's data. You can try to transfer the data to Power BI dataset first
FelipeCostaHave you seen this:
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.
