topic Re: API access underlying report data in Developer

API access underlying report data

johnpmc — Sat, 27 Mar 2021 10:21:57 GMT

Hi all,

I am building a customer project with power BI embedded and although I can access underlying report data on the client there does not appear to be any server side REST API access to it - is this correct or is there another way to access underlying report data without trying to replicate the query used to generate the report visual?

Thanks,

John

Re: API access underlying report data

lbendlin — Sun, 28 Mar 2021 01:06:15 GMT

Assuming your tenant admin has enabled that feature you can use XMLA clients to access the dataset that feeds your reports. That allows you to run MDX and DAX queries etc.

Re: API access underlying report data

johnpmc — Mon, 29 Mar 2021 07:12:53 GMT

Thanks - if I took this approach I would need to attempt to manually recreate the query used to generate the report in MDX/DAX in order to access the underlying data right?

Re: API access underlying report data

lbendlin — Mon, 29 Mar 2021 11:51:43 GMT

You can copy the query for each visual from the Power BI performance analyzer.