Forum Discussion
aage-e
7 years agoNew Member
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 st...
v-jiascu-msft
7 years agoMicrosoft Employee
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,