BeyondERP.Newsletter
Menu

Setup step on the Client performance options page · System administration

Set up Client performance options

Use this page to tune settings that affect users' experience, such as how many rows users can export to Excel.

Business process
Administer system features
Menu item
SysClientPerf
Main table
SysClientPerf
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where system administrators set system-wide client performance settings.
What you do hereUse this page to tune settings that affect users' experience, such as how many rows users can export to Excel.
ExampleFor example, an administrator raises the Excel export limit above the default of 50,000 rows so users can export larger data sets in one go.
Client performance options page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processAdminister system features
Menu pathSystem administration › Setup › Client performance options
Set up firstUsers Microsoft Learn
Used next byOffice app parameters Microsoft Learn
In this process Set up Case categories · Set up Registration categories
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Client performance options1 screen

Use this page to tune settings that affect users' experience, such as how many rows users can export to Excel.

  1. Screen 1

    Review the client performance options

    Go to System administration > Setup > Client performance options

    1. Review the options that affect how the client performs, for example tile counts and form personalization
    2. Review the maximum number of rows users can export to Excel
    3. Close the panel without changing anything, unless a change is needed
    Review the client performance options (zoomed on the outlined fields)
    Show the full screenReview the client performance options
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to System administration > Setup > Client performance options.
  2. Find the Maximum number of rows to export to Excel field.
  3. Change the value from 0 (up to 50,000 rows) to a higher number, up to 1,000,000.
  4. Save the change.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansExampleTable column
Maximum number of rows to export to ExcelThe largest number of rows users can export to Excel; 0 means up to 50,000.Microsoft Learn 100000MaxNumberOfStaticExportRows

Common errors and fixes

MessageWhat to do
An export to Excel stops at 50,000 rowsMaximum number of rows to export to Excel is 0, which allows up to 50,000 rows. Raise it, up to 1,000,000. Microsoft Learn

Test checklist

  1. Set Maximum number of rows to export to Excel and save.
  2. Open a list page with more rows than the old limit and export it to Excel.
  3. Check that the number of exported rows matches the new limit.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Client performance optionsKeep 0 (up to 50,000 rows) unless users regularly need larger exports, then set the smallest value that covers them, at most 1,000,0000 is the default and allows up to 50,000 rows; a higher value lets users export larger data sets in a single session.How many rows can users export to Excel?Setting 1,000,000 for everyone so that very large exports run from the browser instead of through Data management.Test: The export limit applies

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. IT administrators maintain it. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Shared or per companyShared: one setting for all users and companies (the SysClientPerf table has no company field). Microsoft data model
Can it be undoneReversible: The value can be changed back at any time.
If you change it laterA higher limit lets users export larger data sets to Excel in one go; the default 0 allows up to 50,000 rows and the highest value is 1,000,000. Microsoft Learn
Technical architect

6Technical

Menu itemSysClientPerf Checked in Dynamics 365
FormSysClientPerf Checked in Dynamics 365
TableSysClientPerfChecked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SysClientPerf
Data migrationLoad order: Client performance options has no data entity in Data management, so it can't be loaded from a file or a configuration template. Set the value by hand in each environment.Checked in Dynamics 365
Table definitionSysClientPerf columns and relations Microsoft data model
Everyone

8Sources

To cite this step: SA-SETUP-100, Set up Client performance options. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/SA-SETUP-100