Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
The new and improved Power Platform admin center is now generally available. We're currently updating the documentation to reflect these changes, so check back to ensure that you're getting the latest updates.
Viewing metrics for your organization is now an improved experience. You no longer need to install or update a solution. Instead, you can view Dataverse analytics right from the Microsoft Power Platform admin center to quickly view adoption and user metrics for your organization.
To access these reports:
- Sign in to the Power Platform admin center.
- In the navigation pane, select Manage.
- In the Manage pane, under Products, select Dataverse.
- View the Dataverse analytics options on the page.
Required roles to view the reports
Admins with these roles and a license can view the reports in Dataverse analytics:
- Environment Admin - can view reports for the environments that the admin has access to.
- Power Platform admin – can view reports for all environments.
- Dynamics 365 admin - can view reports for all environments.
- Microsoft 365 Global admin – can view reports for all environments.
For more information on the different roles for managing your tenant across the platform, see Use service admin roles to manage your tenant.
Key highlights
Monitor adoption and use: Use data to work toward your goals over a period of time. You can identify your most active users, the number and types of operations they're performing, number of pages requests, most-used entities, workflows, plug-ins, and more.
Manage storage and performance: Optimize performance by monitoring storage quotas, storage use, and top tables by size.
Troubleshoot effectively: Quickly diagnose and troubleshoot errors by drilling down into the details of your top failing workflows and API calls.
Home (default) dashboard
The home (default) dashboard shows you information on the number of active Dataverse users, storage usage, the most active workflows, and more.
Home dashboard details
| Chart element | Description |
|---|---|
| Active Users | Number of active users (unique users) who performed an operation that caused one of these SDK calls:Retrieve, Retrieve Multiple, Delete, Create, and Update. |
| API Calls | Number of API calls made by the environment with a Dataverse database for a selected time period. |
| API Pass Rate | Percentage of API calls pass rate out of total API calls made in the environment with a Dataverse database over a specified time period. |
| Executions | Number of plug-ins were executed in the environment with a Dataverse database over a specified time period. |
| Total Operations | Number of operations (Create, Update, Delete, Read) occurred in the environment with a Dataverse database over a specified time period. |
| Most Active Users Performing Operations | List of most active users who performed an operation that caused a Create, Update, Read, or Delete SDK call in the Dynamics 365 environment over a selected time period. |
| Top Plug-ins by Failures | Number of 10 most failing plug-ins in the environment with a Dataverse database over a specified time period. |
Active users dashboard
The Active users dashboard shows you how many Dynamics 365 users there are, how many licenses are in use, what custom entities are used most frequently, and more.
Active users dashboard details
Note
Exports are limited to a maximum of 3000 records.
| Chart element | Description |
|---|---|
| Total Active Users | Total number of active users (unique users) who perform an operation that causes one of these SDK calls:Retrieve, Retrieve Multiple, Delete, Create, and Update. |
| Most Used Entities | Ten Entities that have the mostRetrieve, Retrieve Multiple, Delete, Create, and Update SDK Calls. |
| Total Page Requests | The number of page-load requests for forms, dashboards, and reports received by the Dynamics 365 server. Pages cached while browsing aren't counted. |
| Total Operations | The number of operations (Create, Update, Deletes, Reads) that occur in the environment with a Dataverse database for a selected time period. |
| Active Users Performing Specific Operations | Total number of active users (unique users) over time who perform an operation that causes one of these SDK calls:Retrieve, Retrieve Multiple, Delete, Create, and Update. |
| Active Users | Number of active users (unique users) in your environment who perform an operation that causes one of these SDK calls:Retrieve, Retrieve Multiple, Delete, Create, and Update over time. |
| Most Active Users Performing Operations | List of most active users (unique users) over time who perform an operation that causes one of these SDK calls:Retrieve, Retrieve Multiple, Delete, Create, and Update. |
| Most Used Custom Entities | List of custom entities that have the mostRetrieve, Retrieve Multiple, Delete, Create, and Update SDK Calls. |
| Most Used OOB Entities | List of out-of-box entities that have the mostRetrieve, Retrieve Multiple, Delete, Create, and Update SDK Calls. |
| Usage Active Users by OS | The number of active users by operating system. |
| Active Users by Device Type | The number of active users by device type. |
| Active Users by Browser | The number of active users by browser. |
| Active Users by Security Roles | The number of active users by security roles. |
| Users by Business Unit | The number of active users by business unit. |
| Number of Creates by Entity | The number of create operations performed by a selected user in the environment with a Dataverse database for a selected time period. |
| Number of Updates by Entity | The number of update operations performed on different entities by a selected user in the environment with a Dataverse database for a selected time period. |
| Number of Reads by Entity | the number of read operations performed on different entities by a selected user in the environment with a Dataverse database for a selected time period. |
| Number of Deletes by Entity | The number of delete operations performed on different entities by a selected user in the environment with a Dataverse database for a selected time period. |
| Total Operations Over Time | The number of operations performed by a selected user in the environment with a Dataverse database over a selected time period. |
| Total Operations by Entity | The total operations performed on different entities by a selected user in the environment with a Dataverse database for a selected time period. |
| Active Users by Entities | The active users distributed over different entities |
| Active Users by Client | The active users distributed by client type |
| Active Users Using More than One Client | The number of active users using more than one client, distributed over different client combinations |
Note
Retrieve and RetrieveMultiple SDK calls are reported as Reads.
Active usage chart update frequency
This table details the frequency of different active usage chart updates.
| Chart | Update frequency |
|---|---|
| Total Active Users | 24 hours |
| Most Used Entities | 24 hours |
| Most Active Users (Reads) | 24 hours |
| Total API Calls | 24 hours |
| Total Page Requests | 24 hours |
| Most Active Users (Changes) | 24 hours |
| Total Operations | 24 hours |
| Active Users Performing Specific Operations | 24 hours |
| Active Users | 24 hours |
| Most Active Users Performing Operations | 24 hours |
| Most Used Custom Entities | 24 hours |
| Most Used OOB Entities | 24 hours |
System Jobs dashboard
This dashboard helps you monitor and troubleshoot workflows.
System jobs dashboard details
| Chart element | Description |
|---|---|
| Workflow Executions | This chart shows the number of workflows executed in a environment with a Dataverse database over a specified time. |
| System Jobs Pass Rate | This chart shows the system job's pass rate as percentage of system jobs executed in the environment with a Dataverse database over a specified time. |
| System Jobs Throughput/Minute | This chart shows the average of system jobs executed per hour in the environment with a Dataverse database over a specified time. |
| Executions and Backlog | This chart shows the number of executions and the backlog for system jobs in the environment with a Dataverse database over a specified time. |
| Most Active Workflows | This chart shows the top-10 most executed workflows in the environment with a Dataverse database over a specified time. |
| Top Workflows by Failures | This chart shows the top-10 most failing workflows in the environment with a Dataverse database over the specified time. Select a workflow to see the failures and their number of occurrences. |
System jobs chart update frequency
This table details the frequency of different system jobs chart updates:
| Chart | Update frequency |
|---|---|
| Workflow Executions | 24 hours |
| System Jobs Pass Rate | 24 hours |
| System Jobs Throughput / Hour | 24 hours |
| Most Active Workflows | 24 hours |
| System Jobs Executions and Backlog | 24 hours |
| Top Workflows by Failures | 24 hours |
Plug-ins dashboard
This dashboard helps you monitor and troubleshoot plug-ins.
Plug-in dashboard details
| Chart element | Description |
|---|---|
| Plug-in Success Rate | This chart shows the plug-in pass rate as percentage of total plug-in executions executed in the environment with a Dataverse database over a specified time. |
| Plug-in Executions | This chart shows how many plug-ins executed in the environment with a Dataverse database over a specified time. |
| Average Plug-in Execution Time | This chart shows average time taken to successfully execute a plug-in in the environment with a Dataverse database over a specified time. |
| Most Active Plug-ins | This chart shows the top-10 most executed plug-ins in the environment with a Dataverse database over a specified time. |
| Top Plug-ins by Failures | This chart shows the top-10 most failing plug-ins in the environment with a Dataverse database over a specified time. |
Plug-in chart update frequency
This table details the frequency of different plug-in chart updates:
| Chart | Update frequency |
|---|---|
| Plug-in Success Rate | 24 hours |
| Most Active Plug-ins | 24 hours |
| Plug-in Executions | 24 hours |
| Average Plug-in Execution Time | 24 hours |
| Top Plug-ins by Failures | 24 hours |
API calls statistics dashboard
This dashboard helps you monitor and troubleshoot API calls.
API calls statistics dashboard details
| Chart element | Description |
|---|---|
| API Success Rate | This chart shows the API success rate as percentage of total API calls made in the environment with a Dataverse database over a specified time. |
| Top API by Failures | This chart shows top-10 failing API calls in the environment with a Dataverse database over a specified time. |
| Total API Calls | This chart shows total number of API calls made in the environment with a Dataverse database over a specified time. |
| Most Used API | This chart shows top-10 most executed API calls in the environment with a Dataverse database database. Adding the individual counts provide the total of the top-10 API calls. This is not be the same as the all-up Total API Calls metric. |
| API Calls | This chart shows the number of API calls made over time in the environment with a Dataverse database over a specified time. Adding up the individual counts equals the Total API Calls count. |
| API peak call rate | This chart shows capacity consumption relative to the API call limit. More information: API peak call rate report |
API calls statistics chart update frequency
This table details the frequency of API calls statistics chart updates:
| Chart | Update frequency |
|---|---|
| API Success Rate | 24 hours |
| Top API by Failures | 24 hours |
| Most Used API | 24 hours |
| Total API Calls | 24 hours |
| API Calls | 24 hours |
| API peak call rate | 24 hours |
API peak call rate report (preview)
Important
- This is a preview feature.
- Preview features aren't meant for production use and may have restricted functionality. These features are available before an official release so that customers can get early access and provide feedback.
The API peak call rate report shows API usage graph with the number of requests per user/application for the selected interval. This report helps you monitor the API usage, and avoid hitting the service protection limits.
| Chart element | Description |
|---|---|
| SDSService and OData | The bars show the max number of API requests by app/users within 5-min interval. The maximum is the number of requests per user per five minutes that is based on your licenses and capacity add-ons. |
| API Peak limit | The peak requests per second recorded by the request count API limit. This is a measure of request count per unit time. |
Analyze API peak call rate
To help interpret and act on the capacity, the graph shows the API peak limit. The bars show the max number of API requests by app/users within a 5-minute interval. The maximum is the number of requests per user per five minutes that is based on your licenses and capacity add-ons.
You can also have a direct view of where your actual use of capacity is relative to the limit so you can be sure that you are within the limit.
When the graph shows that your requests per user/app are beyond the peak limit (identified with a red line), it means that you have reached a peak and your requests are being throttled. The report shows data using a single unit of measure to make it easy to get an overview of API utilization.
API peak call rate is calculated as the maximum of one of the following:
- The peak requests per second (RPS) recorded by the request count API limit. This is a measure of request count per unit time.
- The peak cumulative execution time recorded by the time API limit. Each 150 ms of request execution time is counted as one API call, and then summed up for every 5-minute interval. This is a measure of compute time, converted to an equivalent number of API calls per unit time.
For more information about the API count and time limits, refer to service protection API limits.
API peak call rate example scenarios
API peak call rate is based on either the number of requests or execution time measured by the service protection limits, whichever is greater. One request is equivalent to 150ms of execution time measured by the time limit.
The scenarios below show how the peak call rate is derived based on either request count or execution time using 150ms as the conversion factor from time to count.
Scenario 1: Client sends 150,000 web API calls in 5 minutes that each execute for 50ms.
- Count is 500 requests per second (150,000 per 5 minutes is 30,000 per minute)
- Time is equivalent to 17 requests per second (750,000ms total time, or 5000 calls per 5 minutes (750,000ms / 150ms))
Request count is higher in this case, so the peak rate displayed is 500 requests per second.
Scenario 2: Client sends 300 web API calls in 5 minutes that each execute for 10 seconds.
- Count is 1 request per second (there are 300 seconds in 5 minutes)
- Time is equivalent to 67 requests per second (3,000,000ms total time, or 20,000 API calls per 5 minutes (3,000,000ms / 150ms)).
Execution time converts to a higher request count in this case, so the peak rate displayed is 67 API calls per second.
Optimize API peak call rate
The usage graph can help you identify what users/applications are approaching or exceeding the service protection limits and take actions to mitigate it as necessary.
To optimize limit, consider reducing the number of API requests by user/app or increase the limit by adding more capacity and bring the peak limit (identified with a red line) higher.
Mailbox Usage dashboard
This dashboard helps you monitor email mailbox usage.
Mailbox usage dashboard details
| Chart element | Description |
|---|---|
| Mailbox Details by GEO | This chart shows mailbox details like:
|
| Mailboxes by Server Type | This chart shows the mailbox distribution by server type. |
| Active Email Server Profiles by Geo | This chart shows active server-side synch enabled mailboxes distributed over the geo ___location they are hosted in. |
| Mailboxes by Exchange Configuration | This chart shows the number of mailboxes categorized by their Exchange configuration. |
| Number of Mailbox Configuration Errors | This chart shows the number of mailboxes configuration errors which occurred over the user-selected time frame. |
| Mailbox Usage | This chart shows the number of server-side synch mailboxes over the time range selected by the user. |
| Number of Outlook Mailboxes | This chart shows the number of Outlook mailboxes configured for the organization. |
| Number of Active Email Server Profiles | This chart shows the number of active email server profiles for the time range configured by the user. |
Mailbox usage chart update frequency
This table details the frequency of mailbox usage chart updates:
| Chart | Update frequency |
|---|---|
| Mailbox Details by Geo | 24 hours |
| Active Email Server Profiles by Geo | 24 hours |
| Mailboxes by Server Type | 24 hours |
| Mailbox Usage | 24 hours |
| Number of Mailbox Configuration Errors | 24 hours |
| Number of Active Email Server Profiles | 24 hours |
| Number of Outlook Mailboxes | 24 hours |
| Mailboxes by Exchange Configuration | 24 hours |
Download reports
Select Download to view available downloads and then select any of the reports to download them into Microsoft Excel.
All the download reports, except Active Dynamics 365 Customer Engagement Plan Users by Application, show data for an environment and per the timeline in the filters for the out-of-box Dataverse analytics reports. If you select a certain date range for the out-of-box Dataverse reports, the same time filter applies to the downloads. The maximum duration for data availability is 30 days.
The Active Dynamics 365 Customer Engagement Plan Users by Application report always shows the last 30 days of data at the tenant level.
Download reports dashboard details
| Chart element | Description |
|---|---|
| Active users by device type | List of active users by device type used to access Dynamics 365. |
| Active users by business unit | List of active users by their business unit. NOTE: This is not specific to UI calls, and includes system calls in the context of the user. |
| Active users by security role | List of active users by their security roles. NOTE: This is not specific to UI calls, and includes system calls in the context of the user. |
| Active users by client | List of active users, by client type used to access Dynamics 365. |
| Active users by entities | List of active users distributed by entity. |
| Most active users performing operations | List of most active users (unique users) over time who perform an operation that causes one of these SDK calls:Retrieve, Retrieve Multiple, Delete, Create, and Update. |
| Most used custom entities | List of custom entities that had the mostRetrieve, Retrieve Multiple, Delete, Create, and Update SDK Calls. |
| Most used OOB entities | List of out-of-box entities that had the mostRetrieve, Retrieve Multiple, Delete, Create, and Update SDK Calls. |
| Most active workflows | List of top-10 most executed workflows in the environment with a Dataverse database over a specified time. |
| Most active plug-ins | List of top-10 most executed plug-ins in the environment with a Dataverse database over a specified time. |
| Most used API | List of top-10 most executed API calls in the Dataverse environment database. |
| Active Dynamics 365 Customer Engagement Plan Users by Application | Active Dynamics 365 Customer Engagement plan users by application. Helps customers to know usage across different apps so that when it is time to renew their subscription, they can choose the individual apps to be bought (for example Dynamics 365 for Sales, Dynamics 365 for Customer Service, and more). The Customer Engagement plan, which was a suite of all Customer Engagement applications, is no longer being sold and people need to choose the individual apps to be bought. |
| Non-conformant usage by users with Team Member license | Shows customers how their users (with team-member licenses) are using the product in ways that are deemed not conformant with the use rights entitled to this license, as per licensing guide. |
Environment and date-time range data
You can view data for different environment and date-time ranges. Take these steps to get started:
- Select Change filters.
- Select the desired environment and time-period from the drop-down lists.
- Select Apply to save the changes. All Dataverse analytics reports are available using this selection process.
