Forum Discussion
jwillis07
Advocate I
Advocate IHow to use the $Skip ODATA expression in a loop?
Good afternoon all, I'm trying to call all of the results within an API that has: 6640 total records 100 records per page 67 pages of results (total records / records per page) This is an ev...
A simpler approach is shown in this article/video - Power BI - Tales From The Front - REST APIs - YouTube
You can adapt that approach. Basically, you create a list of number that increment by 100 with List.Numbers, convert that to a table, make your number column a text column and then concatenate the number into your URL on each row. You then expand the column of "Table"s to get your result.
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeTwo things I see that might be the problem.
1. You probably want to use the Query part of the Web.Contents function and not RelativePath. I think this will auto add the ? so probably not needed again.
2. You need an & between "$Skip=" & [Column1]
Try #2 first and then #1 if still not working.
Pat