March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
8 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
10 | |
3 | |
2 | |
2 | |
2 |