cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
scastrontu Frequent Visitor
Frequent Visitor

Pull out data from website

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Pull out data from website

@scastrontu,

 

You may change the page number in URL.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Pull out data from website

@scastrontu,

 

You may change the page number in URL.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.