Hi
I am trying to Get Data using Get Data|Web.
The API I am using relates to Json files. When the data loads it only brings in 1000 rows. My research suggests that I will need a function and a Query to bring in 1000 rows at a time until all the rows are loaded.
Has any one got a tool such as this - or is there a better approach.
I would send a pbix file but I can’t get past the first step so the pbix file would be of little value.
Thank You
Allister
Don’t know if you have already come across this thread, but it addresses your issue directly and provides M code that should be relatively straightforward to modify to adapt to your particular needs:
Hope this is helpful.
– Brian
We hope the answers above helped you @AllisterB 
If not, how far did you get and what kind of help you need further?
If yes, kindly mark as solution the answer that solved your query.
Hello @AllisterB, just following up if the response from @Harsh help you solve your inquiry?
We’ve noticed that no response has been received from you since a few days ago. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @AllisterB, due to inactivity, a response on this post has been tagged as “Solution”. If you have any concern related to this topic, you can create a new thread.