Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
@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.
@FelipeCosta Hi, currently no API for query Dataflow's data. You can try to transfer the data to Power BI dataset first
User | Count |
---|---|
16 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |