Why only extract 100 rows from crewhu api? How can extract all records?

[UserE]

Hi all,

I follow the below website to connect data from crewhu API in Power BI Desktop.

https://get-help-tnt.crewhu.com/hc/en-us/articles/360041925673-Power-BI-Integration-Open-API

However, I can only edit the limit = 1000 to display maximum 1000 records. It cannot display all records. Can anyone help to advise how to do pagniation to extract all records from crewhu api?

Because Crewhu Support replied me that they don't have support to help on this feature. They informed me to ask Power BI Support to help. So, I raised this question here. Thanks for your help in advance.

[AbhinavJoshi]

Hi @UserE. One way is to get data using a python script and setting the pagination in the script, output the result in a csv or whichever format works for you.

[rubayatyasmin]

Hi, @UserE 

Go through this post. It should be helpful

https://stackoverflow.com/questions/46904641/how-to-get-paginated-data-from-api-in-power-bi

also, I found a similar thread

Solved: Extraction - Microsoft Fabric Community