Microsoft Dataverse analytics

We've improved how you view metrics for your organization. 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:

1. Go to the navigation bar on the left side.
2. Select Analytics.
3. Select Dataverse.
4. View the reports on the right side.

Admins with the following 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: 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, over a period of time as you work toward your adoption goals.

• Manage storage and performance: Monitor storage quotas, storage use, and top tables by size to optimize performance.

• Troubleshoot effectively: Drill down into the details of your top failing workflows and API calls to quickly diagnose and troubleshoot errors.

This is the default dashboard that provides information on the number of active Dataverse users, storage usage, the most active workflows, and more.

Use this dashboard to find out how many Dynamics 365 users there are, how many licenses are in use, what custom entities are used most frequently, and more.

Active usage chart data is updated as follows.

Use this dashboard to monitor and troubleshoot workflows.

System jobs chart data is updated as follows.

Use this dashboard to monitor and troubleshoot plug-ins.

Plug-ins chart data is updated as follows.

Use this dashboard to monitor and troubleshoot API calls.

API Call Statistics chart data is updated as follows.

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.

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. 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 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.

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.

Use this dashboard to monitor email mailbox usage.

Mailbox Usage chart data is updated as follows.

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.

Select Change filters.

Select the environment and time-period from the drop-down lists, and then select Apply to save the changes. All the Dataverse analytics reports are available using this selection.