Forum Discussion
Export report data via the rest API
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.
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
3 Replies
Hey, The below blog provides details on how to extract the data from POwerBi via REAT API :
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 needsHi 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!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
