Power BI REST API to fetch Aggregation, Calculation or formula results in Report

[ekimakIA]

Hi,

Can you please help us with the REST API through which we can fetch Aggregation (Sum, Count etc), result and even formula/Calculation applied on the tables in Reports?

Thank you

[V-lianl-msft · Accepted solution]

Hi @ekimakIA ,

Last month the Power BI team announced  the public preview of Power BI REST API support for DAX Queries.

https://powerbi.microsoft.com/en-us/blog/announcing-the-public-preview-of-power-bi-rest-api-support-... 

You can try to use Power Automate to run a DAX query, extract data & save it to a file.

https://www.datalineo.com/post/using-power-automate-to-run-dax-queries-against-your-power-bi-dataset 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.