Forum Discussion
Convert a value of type Record to type Text
In case it helps, FYI that I just put out a video on using REST APIs with power query. It shows how to get the count and use it to create a list of numbers to make multiple calls with $skip or offset to get all the data (so don't have to worry about pagination).
Power BI - Tales From The Front - REST APIs - YouTube
Regards,
Pat
Microsoft EmployeeIn case it helps, FYI that I just put out a video on using REST APIs with power query. It shows how to get the count and use it to create a list of numbers to make multiple calls with $skip or offset to get all the data (so don't have to worry about pagination).
Power BI - Tales From The Front - REST APIs - YouTube
Regards,
Pat
Dear mahoneypat thank you for your reply and usefully post, but in my case i will not search for a value so i will not enter a value, the value will be my module like "Student, Orders, Clasess" so if i call one page then invoke function to get all pages that i want to loop over, right?
if not how i will applay the same logic for my first API call to loop over?
mahoneypat I have revise my query i was missing a few things and now all is good and I'm using your logic, but i have one issue, that in my API i have 861 Pages and it only load the first 460 page which is the half.
And onle more thing and I think you can help me in that, i'm trying to apply a delay duration to delay the API call by 2 or 3 seconds so do you think it is possible, as i tried to apply that but not working.