Forum Discussion
Full Comprehensive PowerBI Service Audit
Hi icassiem ,
For more details, you can refer the below Microsoft Documentations:
1.Power BI PowerShell Overview & Installation: Power BI Cmdlets reference | Microsoft Learn
2.Connecting to the Power BI Service:Connect-PowerBIServiceAccount (MicrosoftPowerBIMgmt.Profile) | Microsoft LearnHere are some mapping to your requirements:
1.Report names & count:Get-PowerBIReport (MicrosoftPowerBIMgmt.Reports) | Microsoft Learn2.Workspace names, count, members:Get-PowerBIWorkspace (MicrosoftPowerBIMgmt.Workspaces) | Microsoft Learn
3.Active/inactive workspaces:Get-PowerBIActivityEvent (MicrosoftPowerBIMgmt.Admin) | Microsoft Learn
4.Active users (names) > [Get-PowerBIActivityEvent]
5.Inactive users > Compare all users (Get-PowerBIWorkspaceUser) with active list from Get-PowerBIActivityEvent
6.Report usage (including link views) > [Get-PowerBIActivityEvent]
7.Get-PowerBIDataset (PowerShell):Get-PowerBIDataset (MicrosoftPowerBIMgmt.Data) | Microsoft Learn
8.Get Refresh History (Power BI REST API):Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Learn
9.Failed refreshes > [Get-PowerBIRefreshHistory]10.Data size per workspace > Admin API in Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn or Premium Capacity Metrics App
11.Personal workspaces > Get-PowerBIWorkspace -Scope Individual
Thank you.
Hi icassiem ,
For a one-time or periodic Power BI Service audit covering:
1.Refresh Failures Summary
Use the Power BI Activity Log via the Admin Portal or Microsoft 365 Compliance Center. Filter for RefreshDataset events to identify failed refreshes across all workspaces.
2.Gateway Analysis
Go to the Manage Gateways section in Power BI Service. You will find:
Gateway status,Connected data sources,Admins and users.This helps you assess gateway health and usage.
3.License Usage
Use the Microsoft 365 Admin Center to view:
Assigned Power BI licenses (Pro, PPU, Premium),Active vs inactive users,Last activity date (to identify unused licenses)
For a Full Audit you can also:
Use the Power BI Admin Portal to export workspace and user data.Access the Power BI Activity Log for detailed user actions.Consider the Power BI Capacity Metrics app if you're using Premium.
Thank you.