Export report data via the rest API

[MorNag]

Hi, I have a report on the service that I want to fetch the report columns results via the REST API, is it possible?
I want to get the report data for the backend side script (with no visualization).
The report is not pushed report, and use the Incremental refresh.

Thank you.

[NandanHegde]

Hey, The below blog provides details on how to extract the data from POwerBi via REAT API :

https://datasharkx.wordpress.com/2023/03/02/overcoming-data-size-row-limitations-of-power-bi-rest-ap...

can you be please provide some additional context what you mean by get the report data for the backend side script (with no visualization) ?

Because you can write a query to extract the data from the underlying dataset as per your needs

[MorNag]

Hi @NandanHegde  thanks for the quick reply!
I want to fetch the report data to script in NODE JS or PHP, only the data without any visualization (for example as an array).

"Because you can write a query to extract the data from the underlying dataset as per your needs"

Where can I find documentation on how to do it ? I work with the REST API of the BI but the data that I can find on the report/page/dataset/dashboard is mostly general information and not the content itself.

thanks again!

[MorNag · Accepted solution]

Hi, 
The solution that works for me - create in the service paginated report and then I was able to export the report in csv/xslx format to my backend script