Forum Discussion

MorNag's avatar
MorNag
New Member
2 years ago
Solved

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)...
Need Help
  • MorNag's avatar
    MorNag
    2 years ago

    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

NandanHegde's avatar
NandanHegde
Super User
2 years ago

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-api-for-automated-data-extraction-from-dataset/

 

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's avatar
    MorNag
    New Member
    2 years ago

    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's avatar
      MorNag
      New Member
      2 years ago

      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