Forum Discussion

NDM's avatar
NDM
Frequent Visitor
1 year ago
Solved

Connection error with Standard Business Central API (pagination)

Hi all,   I'm working with Business Central and I use Power Bi to do reporting on the data. The connection with a bearer token works perfect, but the result of this API is always 20.000 rows becau...
Need Help
Show and Tell
Tips and Tricks
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi NDM ,

    Business Central API has a default row limit of 20,000 per page.

    odata.maxpagesize can't be greater than the ODataServicesMaxPageSize server setting for on-premises and 20000 for online.

    Reference: Server-Driven Paging in OData Web Services - Business Central | Microsoft Learn
    If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

    Thanks and Regards
    Chaithra

NDM's avatar
NDM
Frequent Visitor
1 year ago

Hi Chaithra,

 

thanks for your response, but isn't there a way to import more then 20.000 rows ??