Forum Discussion
Power BI Loading only 25 Records
Hi Folks, I am fetching data from Websites using the Web option
I am using 2 links -
1- https://www.bollymoviereviewz.com/2013/10/shahrukh-khan-box-office-collection.html
from this URL i am getting all the records from table 1
2- https://www.imdb.com/list/ls526729711/?view=detailed&sort=list_order%2Casc
but form this URL i am only getting 25 Records.
I am not getting a way to fetch all the records frm this URL.
Is there any way we can get the all the data.
I appreciate your help
The behaviour you have is related to the pagination.
Check this old thread : https://community.fabric.microsoft.com/t5/Power-Query/How-to-get-data-from-a-web-that-has-a-paginated-table/td-p/2679198
Meanwhile I recommend that you use the IMDB API : Getting Access to the API (imdb.com)
2 Replies
The behaviour you have is related to the pagination.
Check this old thread : https://community.fabric.microsoft.com/t5/Power-Query/How-to-get-data-from-a-web-that-has-a-paginated-table/td-p/2679198
Meanwhile I recommend that you use the IMDB API : Getting Access to the API (imdb.com)
Thank You AmiraBedh .
