Updating data using an API

[Syndicate_Admin]

Hello

I managed to connect to an API using the "Blank Query" connection method, I entered a script in M language and I managed to extract records and load them into my model. When I publish it to Power Bi Services and configure its periodic update I come across this message.

Is there a solution? Is there any other method that allows data refresh via an API?

Thank you

Mario

[MarioYepes]

Hello

This is my M script and it's the way I extract the data, the API handles pagination so I have to read all its pages and bring up to a maximum of 100 records per page.

[lbendlin]

Please follow the documentation.  Use RelativePath and Query parameters.

Web.Contents - PowerQuery M | Microsoft Learn

[lbendlin]

needs more details. Please show a sanitized version of your Power Query code.