Forum Discussion
Power query does not upload all records
Super UserYes, the issue isn't on Power Query, it's that the API structure if updated must have placed a limit of records to return in a call. You would need to check the documentation to validate that and see if you can modify the parameter or if it has a threshold (usually if it isn't specified the API takes the default value of the items to return which may or may not be its threshold). If it indeed has a threshold you need to adjust your solution with functions and parameters to address the API pagination.
Thank you for the reply. But I use this code for over a year and it was working untill today.
According to the Airtable API changelog, the latest change was made in November 2024 and it was about this:
Multiple OAuth token refresh requests now only invalidate access if the number of requests exceeds 10 per second
So I do not think that it is about the API connection. Do you have any other idea why this happen?
Thanks!
- ray_aramburo
Is this a one time issue or have you seen it persist several days?
It is happening since today. Yesterday is was alright.
- ray_aramburo
I would give it one day to monitor the issue, might be because the API is throttled/has a downtime, because they are updating the API or any other factor. If issue persists, I would start digging deeper. I can't replicate your code due access and permissions but I'll check the documentation to see what I can find.