of the
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.
- Database owner must have external access assembly/unsafe assembly permission
- SQL database Trustworthy property must be set to “on.”
With these settings in place, your monthly grouped charts should render correctly.
Hi,
Thank you for your post.
I did these steps but its not working still for me.
My Environment:
Dynamics 365 CE Version 2104 (9.1.1.914) (DB 9.1.1.914) 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