Forum Discussion

Magnus70's avatar
Magnus70
Frequent Visitor
4 years ago
Solved

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 importe...
  • Magnus70's avatar
    4 years ago

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

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