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