Forum Discussion
Why only extract 100 rows from crewhu api? How can extract all records?
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.
2 Replies
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
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.
