Forum Discussion
Only 100 posts/rows out of 1200 post/rows imported from web
Hi!
When I try to import data from web via a rest API into Power BI I only get 100 posts out of 1200 post from the database imported.
Are there any settings I should do to get alla posts imported or other tips?
Best regards
Magnus
I saw this answer but at this moment I don't have a clue about CKAN resource and new settings.
I can't see that I have any option to change the settings from 100 rows so I will probably have to talk to the company that provided the Rest API.
Example of settings concerning import
Same picture for me. Missing settings I presume?
The solution was to include a filter parameter in the URL query string like this.
https://......Test_API/v1/order?PayingCustomerId=20784&MaxRecords=2000
1 Reply
The solution was to include a filter parameter in the URL query string like this.
https://......Test_API/v1/order?PayingCustomerId=20784&MaxRecords=2000