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

Question

Hey,&nbsp;I am looking to retrieve all pages from an api using an Invoked fucntion.&nbsp;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?&nbsp;Thanks,&nbsp;Jon

fowmy · Answer

magnifybi&nbsp;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&amp;t=2s

magnifybi · Answer

Preview.Error: The current preview value is too complex to display.Details:&nbsp;I got the following error...

mahoneypat · Answer

Here is another video with a different approach to consider.
(6) Power BI - Tales From The Front - REST APIs - YouTube
&nbsp;
Pat
&nbsp;

Forum Discussion

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

3 Replies

Related content

Invoke Custom Function

Invoke Pipeline vs Invoke Pipeline (Legacy)

Invoke Pipeline

Invoke pipeline error

Invoke Pipeline Performance