The Situation

Out-of-the-box Power BI usage reports are limited to specific workspaces - admins can’t view report usage across multiple workspaces or check for improper use of Premium features. Additionally, admins can’t analyze long-term trends as usage reports only show the last 30 days’ data. Without access to company-wide consumption details, admins can’t ensure teams are following org guidelines and best practices.

Our Solution

Our Power BI Governance report tracks your organization’s Power BI adoption details and usage patterns for reports across all workspaces. Admins can easily identify clusters of reports that are refreshing at the same time, failing frequently, or refreshing slowly. A single point of access, our report helps you make quick decisions regarding your organization’s Premium capacity workload.

With Our Solution, You Can

Export your organization’s Power BI usage data
View adoption details (total report users and viewers over time)
Access refresh history, workspace-level governance, and data sources across reports

Target Audience

Power BI admins
Premium capacity admins
Leadership of organizations in the process of adopting Power BI

Features

C# Utility that pulls data daily with Power BI Admin REST APIs (data is stored in an SQL database)
Ability to slice data by report, browser, consumption type, and location
Consolidated heatmap of high-refresh times
List of users with access to workspaces, including type of access
Enterprise gateway details, including available data sources and user access list
Highlights how often users use specific Power BI functions such as Export, Analyze in Excel, Download Reports, and Edits
Identifies pro users that haven’t used pro features in the last few months

Prerequisites

Service Principal (AAD application) with access to query Admin REST APIs
Non-MFA account with admin access to tenant and premium capacity