Only 100 posts/rows out of 1200 post/rows imported from web

[Magnus70]

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

[Magnus70 · Accepted solution]

The solution was to include a filter parameter in the URL query string like this.

https://......Test_API/v1/order?PayingCustomerId=20784&MaxRecords=2000

[Magnus70]

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?

[Magnus70]

I saw this answer but at this moment I don't have I clue about CKAN resource and new settings.

Any idea anyone? 🙂