Pull out data from website

[Anonymous]

Hi,

I've looked at different posts but haven't seen any solution.

I have this webiste https://gtr.ukri.org/search/outcomes?term=*&fetchSize=100&selectedSortableField=&selectedSortOrder=

If I used this link on PBI, but I only got the first page (you to navigate through 1000 pages of results). Someone told me there's a way to modify the link so it can take all the results of the website instead of clicking each single page.

I tried to changed "100" (100 means the number of results I asked to visualise per page) to "1000" or higher... but an error came.

Thanks.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may change the page number in URL.

https://community.powerbi.com/t5/Desktop/Stopping-when-looping-through-a-paginated-API-feed/m-p/310382#M137477