Tip #928: When CRM monthly charts won’t render

In Dynamics 365/CRM on premises, if you create a chart and group by month and find that it doesn’t render, you may need some additional SQL permissions.

With these settings in place, your monthly grouped charts should render correctly.

One thought on “Tip #928: When CRM monthly charts won’t render

  1. Hamid Reza says:


    Thank you for your post.
    I did these steps but its not working still for me.

    My Environment:
    Dynamics 365 CE Version 2104 ( (DB on-premises
    Microsoft SQL Server 2019 (RTM) – 15.0.2000.5 (X64)

    for example when I try to run “Cases by Origin (Per Day)” chart of Case Entity I encounter error “An error occurred while the chart was rendering.”

    do you have any suggestion ?

    Best Regards

Leave a Reply

Your email address will not be published. Required fields are marked *