Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I use API as a source and it gives me the following result:
result = List
total_results = 11829
total_pages = 592
Each page contains 20 results. My source code ends with the "page=1", "page=2" parameter. I was planning copy and paste queries before I noticed that there are so many pages. I need to append all the results to one table.
Is there a way to loop my request using QueryEditor for each page that is needed to get all data out?
At first, you can use the total pages to generate a number list, say(1,2,3...592 in each row), check Nested Loop With List.Generate In Power Query.
And then call the API in each row by passing the page number and extend the reponse text(json,xml). This link may give you some inspiration.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |