I have a substantial amount of case records where I want to see which values are selected the most frequently for 2 fields on it.
I can't use charts because there's too many records for it to render. I am even getting an error trying to export the data. Does anyone know a way I can find out how many selections there are for 2 different fields on here?
*This post is locked for comments
Hi,
Power BI is the good alternative in achieving this. You can fetch the case records in Power BI and get the count of how many times each value is selected.
technet.microsoft.com/.../dn708055.aspx
Hope this helps.
Hi,
PowerBI is impressive as far as i have seen it and if it is in-depth analysis on the data then would recommend PowerBI as well.
But if you are looking for counts and your query can be configured in Advanced Find/Fetch XML then you may use the tool - "FetchXML record View Counter" in XRM Toolbox.
You may extract the FetchXML from Advanced Find and copy it in the tool.
-Aamer
Power BI is the best approach. you can refer this:
community.dynamics.com/.../integrate-power-bi-for-custom-entities-of-microsoft-dynamics-365
Hi CRM Learner 8,
I would highly recommend looking at Microsoft Power BI. Power BI does a great job with large datasets, I am working with one customer and one of the Order datasets has 2+ million records. Overall you are able to create complex visualizations that all work together and react to selections.
Hope this helps.
An SSRS Report is likely your easiest way to get to that data if you're having trouble getting it through the UI.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (