Retrieve all pages from an api using an Invoked fu...

magnifybi · ‎04-30-2021

Hey,

I am looking to retrieve all pages from an api using an Invoked fucntion.

I have this set up and can create a static list of numbers, but what is the best way to know how many pages exist so I can only call that many?

Thanks,

Jon

mahoneypat · ‎05-01-2021

Here is another video with a different approach to consider.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Fowmy · ‎04-30-2021

@magnifybi

Please check out this video. When you have unknown number of pages to iterate, this technique works well.

https://www.youtube.com/watch?v=vhr4w5G8bRA&t=2s

Did I answer your question? Mark my post as a solution! and hit thumbs up

magnifybi · ‎05-01-2021

Preview.Error: The current preview value is too complex to display.
Details:

I got the following error...

Retrieve all pages from an api using an Invoked function, not just a from a manual page No. list