Microsoft Dynamics CRM (Archived)

MSCRM Dashboard Chart issue

(0) Share

Report

Posted on by ashok teja

290

Dear All,

We recently encountered an issue with dashboard chart, when we view the dashboard the chart shows error like below

So to fix this issue we manually increased the max limit of 'AggregateQueryRecordLimit' to 500000 but it is causing the performance issue, I would appreciate if anyone could let me know the work around.

USE MSCRM_CONFIG

UPDATE DeploymentProperties

SET IntColumn = 500000

WHERE ColumnName = 'AggregateQueryRecordLimit'

SELECT ColumnName

, IntColumn

FROM DeploymentProperties

WHERE ColumnName = 'AggregateQueryRecordLimit'

*This post is locked for comments

All responses (2)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: MSCRM Dashboard Chart issue

Hi Ashok,

if you need is to deal with a lot of data, probably the best solution is to start think about external solutions like Power BI.

You could integrate it directly with OnPremise CRM

https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-Power-BI-to-Dynamics-2016-on-premise-with-IFD/m-p/190413#M10705

If you meet limits over CRM, you could integrate it directly to CRM SQL Database.

Hope it helps.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com
Suggested answer

Wayne Walton 13,726 on at

Like (0)

Report

RE: MSCRM Dashboard Chart issue

There are a few ways to handle this:

1. reduce your views to make your charts work with fewer records

2. Monitor server performance when loading your charts and see why I/O limits are and upgrade that hardware (likely Disk I/O).

3. Move your large-volume reports to a BI tool that actually is designed large volumes of data. CRM charts are designed to be tactical, not huge overviews of all your data.