Forum Discussion

aage-e's avatar
aage-e
New Member
7 years ago

How to query PowerBI-data with c#

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.

Need Help

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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.

    How-to-query-Power-BI-data-with-c

    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,