Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
So, I have this API which is paginated by the GeneralCode of the last row of the table. The parameters used in the endpoint are the code itself, and a range of dates. I tried to loop through the pages using the solution provided by PBI guy as seen here (https://pbi-guy.com/2022/07/05/how-to-loop-through-an-api-with-power-bi-without-knowing-last-page/). I havent achieved any success because my loop within the list.generate function only run the first iteration. The json returned by the API is shaped as seen below:
["LastCode":0000,
Results:{{ code: 0000
Value: 11111},
{ code: 0001
Value: 11112} ........}]
please show a sanitized version of your Power Query code.