Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How can I load in a API with multiple pages in Power BI

Hi Guys, I'm working on creating some Terraform reports and one of the things I want to be able to do is extract all the workgroups. I have the API but due to restrictions in the API I can only pull ...
Need Help
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

Hey Anonymous ,

 

you can write a function in Power Query that is doing the transformation for each page.

Then you loop 135 times over this function with changing parameter. Take a look at the following blog article on how to do that:

How to loop through an API with Power BI without knowing last page – PBI Guy (pbi-guy.com)

 

That should get the job done.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

Anonymous's avatar
Anonymous
Not applicable
3 years ago

OMG, I had a look at that link and it took about an hour but got there in the end and I've implemented the dynamic approach. For anyone with this kind of issue the post above it great as if I wanted to cheat I could have also saved a lot of time and just hardcoded the page limits in (shown in the post).

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    3 years ago

    Hey Anonymous ,

     

    I'm happy to hear that you could solve it.

    Yes, it's not easy, but the article mentioned above from Kristian Bubalo is by far the best approach in my eyes.

     

    Best regards

    Denis