Forum Discussion

JoeFields's avatar
JoeFields
Frequent Visitor
3 years ago

How to limit OnTake to 100 rows in Custom Connector

I am trying to implement Table.View with a REST API but the API has a limit of 100 items per call. I saw PQ trying to fetch 200 items at a time which caused errors so I modified the OnTake handler as...
Need Help
JoeFields's avatar
JoeFields
Frequent Visitor
3 years ago

Hello Xiaoxin, we are implementing paging already in our connector which works well but it is downstream from the OnTake so this would not resolve the issue. It appears that OnTake is set to receive a default of 200 items per page and there is not a clear way to override this default to a different value. If I cap OnTake to 100 results, we get errors because it is expecting 200 results.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI JoeFields,

    I'd like to suggest you filter on the output result to limit the result amount instead of the directly overwrite the parameters. (current power bi data connectors does not include any writeback features)

    So if these properties can't be configured/defined in the API request, it may means you also can't customize them at power bi desktop side.

    Regaerds,

    Xiaoxin Sheng