Looping data pull due to API limitation

Question

Hi guys.&nbsp;I am facing a problem with CISCO AMP API. I need to pull data but I am limited to 500 rows and any number greater than 500 gives error:&nbsp;&nbsp; DataSource.Error: Web.Contents failed to get contents from 'https://api.eu.amp.cisco.com/v1/computers?limit=501' (400): Bad Request&nbsp;&nbsp; Details:&nbsp;&nbsp; DataSourceKind=Web&nbsp;&nbsp; DataSourcePath=https://api.eu.amp.cisco.com/v1/computers&nbsp;&nbsp; Url=https://api.eu.amp.cisco.com/v1/computers?limit=501I want to try to loop that data pull to give me next 500 rows multiple times to have all of 16k rows.Can anyone help me with that? This is overwhelming me.&nbsp;

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
Please have a look at below posts to check if they could help.
https://community.powerbi.com/t5/Desktop/how-to-create-a-query-that-paginates/td-p/20047/page/7
Loop through Multiple Web Pages using Power Query
Iterating over multiple pages of web data using Power Query
For 3rd party Links:
Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.
Regards,

anonymous · Answer

Thank&nbsp; you for your response but the thing is all records are within one sheet, on one page so the pagination solve different issue from what I see.

Forum Discussion

Looping data pull due to API limitation

2 Replies

Related content

Data limit Issues

Copilot, limitations?

Automatic data refresh limition

Fabric Data Agent Limitations of 25 items

Stacked Column Chart Data Limit Issue