How to query PowerBI-data with c#

[aage-e]

We have PowerBI-reports with calculations.

Based on these reports and measures we want to develop API's in c#

When the data is in a SSAS-cube, writing a DAX query to read data from a model is straight forward.

Is it possible to do a similar operation reading data from the PowerBI-model?

KR,

Aage.

[v-jiascu-msft]

Hi Aage,

The Power BI model isn't like the SSAS-Cube. SSAS Cube runs as a service while the Power BI cube is just a file. To be honest, I don't find a way to read data from the Power BI file directly. But we can read the data just like the SSAS model. Please refer to XML-structure and the additional snapshot.

About how to query data with C#, please refer to how-to-retrieve-data-from-ssas-cube-to-datatable-by-c. Since it isn't a service that can keep running, maybe the APIs aren't necessary.

Best Regards,