Forum Discussion
Power Query - Number must be either non-negative and less than or equal to Int32.MaxValue or -1.
I am running an Rest API through Power Query, using List.Generate. It was working very happily until suddenly it is pulling through pages with null values, resulting in the following message: "Num...
As you can imagine it is not possible to help much more without access to the API. Try adding more robustness to the exit check in the List.Generate part. In addition to checking for null you should also check for an empty list.
Thank you lbendlin I was able to refactor the function, but not sure what you mean with the [Query = [page = Page]] attribute?
Once I have refactored the function, the same error still appears when I load it in desktop.