Microsoft Fabric Updates Blog

Power BI Admin portal Usage metrics dashboard retirement

Effective July 2024, the Power BI Admin portal Usage metrics dashboard will be removed. Comparable insights are now supported out-of-the-box through the Admin monitoring workspace (preview).

Admin monitoring in Fabric overview

The Admin monitoring workspace provides several Power BI reports and semantic models, including the Feature Usage and Adoption report which focuses on Fabric tenant inventory and audit activity monitoring. Over the recent months, the team has made incremental improvements to the reporting provided out of the box, including adding inventory-level analysis within the Feature Usage and Adoption report. In this post, we’ll focus on the Feature Usage and Adoption semantic model which unlocks many curated insights similar to the legacy Usage metrics dashboard in the Admin Portal.

To learn more about the Admin monitoring workspace, please read the documentation page.

Admin portal Usage metrics dashboard overview

The legacy dashboard provides some baseline inventory and usage stats for several Power BI item types: Reports, Semantic models (formerly called Datasets), and Dashboards. We have split the legacy Admin portal Usage metrics dashboard elements into four sections.

Figure 1: Power BI Admin Portal Usage metrics dashboard elements
Section #Insight CategoryMetricData Source
1InventoryCount of items by Item typeMetadata
2AuthoringCount of authored items by User IdMetadata
3UsageUnique user count of consumed DashboardsAudit
4UsageUnique user count of consumed content This is via the Get Data process so it includes not just Fabric items like semantic models, but many other data sources like content packs, files and databases.Audit
Figure 2: Breakdown of Power BI Usage metrics dashboard elements

Please note that there was once a separate section of the Admin Portal usage metrics dashboard for “Groups”. This section is no longer supported, because we do not aggregate authoring and usage of content by Groups, whereby “Group” we mean “distribution groups and mail-enabled security”. Instead, we only show inventory and audit logs by each unique User principal name (UPN).

Metadata-based insights on inventory and authoring

The Inventory page inside the Feature Usage and Adoption report provides an overview of all Fabric items. At the bottom section of the report page, we have the decomposition tree visual.

To learn more about using the decomposition tree visual, please read the documentation page. The decomposition tree visual lets users visualize and aggregate data across multiple dimensions. In this case, we will use the decomposition tree visual to effectively summarize inventory by item types and authors.

Figure 3: Selecting the desired dimensions from the decomposition tree visual on the Inventory page of the Feature Usage and Adoption report

To simplify the comparison, we have cross-filtered the Inventory page by Item type = {Dataset, Report, Dashboard} in order to provide similar inventory insights to the Admin Portal Usage metrics dashboard.

Figure 4: Inventory page inside the Feature Usage and Adoption report

Audit-based insights on content usage

One quick way to get specific information about Fabric content usage is through the ‘Explore your data’ feature in the Power BI service.  The exploration can also be saved later as a report.

To learn more about using Explore your data in the Power BI service, please read the documentation page.

Following along with our previous example, if we are interested in overall dashboard consumption, we may have some questions in mind:

  1. Which are the most consumed dashboards (by activity counts)?
  2. Which are the most popular dashboards (by unique users)?

To start with, let’s add the “Item type” dimension as a filter, and only include Dashboards.

Then, let’s add the “Operation” dimension as a filter, and only include Dashboard consumption events (exclude authoring activities). Then, we are ready to add the reporting dimension “Item name”, and the corresponding measures “Active users” and “Activities”. 

This provides similar consumption insights to the Admin portal Usage metrics dashboard (section 3 in Figure 1), but also explains how many consumption activities actually occur for the most popular dashboards.

Figure 5: Explore the Feature Usage and Adoption semantic model to get dashboard usage

We can take this analysis a bit further and look at overall Fabric consumption activities.

Figure 6: Explore the Feature Usage and Adoption semantic model to get overall content usage

This quick exploration can provide some of the insights originally provided by the Admin portal Usage metrics dashboard (section 4 in Figure 1).

Please note, currently we only limit Consumed Packages to Fabric items such as semantic models. To learn more about inventory lineage and data sources, please refer to Fabric Metadata scanning overview.

Admin Monitoring workspace

This example comprises one of the multiple scenarios which organizations can now unlock as part of the out of the box reports and semantic models within the Admin monitoring workspace (preview).  The experience is specifically tailored to enable a flexible data model, a holistic “tenant-level” view of inventory, usage, and other auditing scenarios.  As we incrementally add content, the workspace automatically updates.

During the preview period, we’ll be listening to feedback from customers and incorporating it into platform evolution and updates to the workspace and related content.

Next Steps

See here to learn about Admin monitoring workspace and here to learn about the Feature Usage and Adoption semantic model /report.

Relaterade blogginlägg

Power BI Admin portal Usage metrics dashboard retirement

oktober 7, 2024 från Alex Lin

Introducing Managed VNet Support for Fabric Eventstream! By creating a Fabric’s Managed Private Endpoint, you can now securely connect Eventstream to your Azure services, such as Azure Event Hubs or IoT Hub, within a private network or behind a firewall. This integration ensures your data is securely transmitted over a private network, enabling you to … Continue reading “Secure Data Streaming with Managed Private Endpoints in Eventstream (Preview)”

oktober 4, 2024 från Jason Himmelstein

We had an incredible time in our host city of Stockholm for FabCon Europe! 3,300 attendees joined us from our international community, and it was wonderful to meet so many of you in person. Throughout the week of FabCon Europe, our teams published a wealth of valuable content, and we want to ensure you have … Continue reading “Fabric Community Conference Europe Recap”