Forum Discussion
pagination problem import
- 4 years ago
ThanK you for your posts, I finally find a solution using a function with Loop and calling the function again!!
Please see this video for a simpler way to apporach this.
Power BI - Tales From The Front - REST APIs - YouTube
Pat
Thank you for your reply Pat,
The problem is that with the API of my url i don.t get the pagination information. Im not high skilled with Query M and is dificult to me to understand how to use the value of a record in the next cycle.
As i posted before a need to import the records form my url. I have a limit of 100 records by query. So I had to use the lower value of the "Id" field to recuperate the next 100 records. I would like to limite the querys to 50 (for instances) in ordert to not importing a huges amount of records (just 100x50).
I will appreciate a lot your help. (If you have a code that i could use as an exemple it woul be very worht for me)
Thank you in advanced,
Ignacio