Forum Discussion

Atoma's avatar
Atoma
Frequent Visitor
2 years ago

Read all data from dalux Api

Hello everyone, I'm trying to link PowerBi to the opening API of an application we're using. Powerbi can only read data from one page. I would like it to read all the data. If you take the task. How...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Atoma ,

If you are trying to read all the pages from an API, you can use the REST API for Power BI. The API returns a list of pages within the specified report from My workspace. You can use this API(Reports - Get Pages)to get all the pages containing data. The required scope for this API is or Report.ReadWrite.AllReport.Read.All

Below is the official link will help you:
Reports - Get Pages - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Best Regards,

Xianda Tang

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

  • Atoma's avatar
    Atoma
    Frequent Visitor
    2 years ago

    thank you for your reply. This function lets you know how many pages the API contains. I just want powerbi to read all the pages containing data. As the number of pages can change, I would like this to be automatic. Without manually filling in the number of pages each time it is updated.