'How to get all data from API in Power BI

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

apipowerbipowerqueryoffsetm


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions