web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Ask for the solution t...
Microsoft Dynamics CRM (Archived)

Ask for the solution to maximum limit error on the dashboard

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

I got an error message on the dashboard "Maximum limit is exceeded record. Reduce the number of records" because the data exceeds 50,000 records.  It's Online CRM, not on-primises, so changing the AggregateQueryRecordLimit setting in the database doesn't work.

We need to see charts of the data during several years on the dashboard(definitely more than 50,000 records).  Is it possible to resolve it by program?  Something like that separate them into small amount of data using FetchXML(less than certain count per each query) but aggregate and deliver them to the final report to show the chart of complete data(>50,000) on the dashboard?

Could anyone give me some idea or feasible way to implement it.

Thank you for your help.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Shahbaaz Ansari Profile Picture
    Shahbaaz Ansari 6,211 on at
    RE: Ask for the solution to maximum limit error on the dashboard

    Hi van,

    CRM online has limitation due to performance reasons. And as it is online instance, all the database updates are not available. For charts and grids displayed in dashboards, Microsoft Dynamics CRM allows users to run queries that have a dataset that is under 50,000 rows.

    Please check below article for the same,

    technet.microsoft.com/.../dn792525.aspx

    If you find it helpful, Please mark as verified.

    Best Regards,

    Shahbaaz

  • ashlega Profile Picture
    ashlega 34,477 on at
    RE: Ask for the solution to maximum limit error on the dashboard

    I remember having to deal with this by building an external tool that would run overnight to aggregate those numbers into a custom entity.. then the dashboard would display charts using that custom entity. Problem is - you need to build the tool, to schedule it somewhere, and , from the dashboard, you won't be able to drill down to the actual data - only to the aggregated data.

    Other options? Maybe power bi..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
UllrSki Profile Picture

UllrSki 2

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans