Looping a DAX query

[Anonymous]

Is there a way to apply a loop on the DAX query which returns paginated json response? I want to loop through all the pages and combine the data obtained. 

ex:

for(p=1;p<=total_pages;p++){

Json.Document(Web.Content("https://example.com/page=& p &")

//code to append

}

Something like the above code.

Thanks,

Vibhuti

[ImkeF]

Absolutely, just that you have to use the M-language in the query editor:

https://www.mattmasson.com/2014/11/iterating-over-multiple-pages-of-web-data-using-power-query/ 

[Anonymous · Accepted solution]

Hi @ImkeF,

I followed this blog: https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78

to solve my issue. 

Thanks a lot for your reply. I really appreciate it. 

Regards,

Vibhuti