0

I'm following this post to make a connection with pagination to an API (Marvel API as a study) by Power BI, and I realized that even generating a list with the number of API pages for each page, the same 20 records are requested.

Then I found this other post that talks about the "offset" and "limit" parameters, but I didn't understand the operation and how I should use it.

Get data> Web> API path enter image description here

M language generated enter image description here

Invoke function enter image description here

gugoan
  • 770
  • 2
  • 11
  • 35

1 Answers1

0

I solved it as follows: I created a list for the "offset" parameter of 100 in 100 and called the function passing this column in the "page" of the IPA URL

= List.Generate(()=>0, each _<=TOTAL_REGISTROS, each _+100)

enter image description here

gugoan
  • 770
  • 2
  • 11
  • 35