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.
MFelix , rohit1991 v-venuppu Thank You for helping me
MFelix my org does not have fabric and i have no funds for this exercise, so i wont be able to purchase for this once off task
rohit1991 can you please provide the "How" in terms of the actual code examples on calling each API or links for each of the 14?
I dont have Premium for Premium Metrics App and i think i can skip this What You Can't Fully Do Without Azure
The list was defined by me so that could provide pivot tables view for my senior and stakeholders, hence anything important i am missing "Point 15"
Hi icassiem
Additional Items You Might Be Missing :
-
Additional Items You Might Be Missing :
- Refresh Failures Summary
- List of all datasets with refresh failures (last 30/60/90 days)
- Helps spot reliability issues early
- Power BI Apps:
- Number of published apps, usage stats, and access mapping
- Paginated Reports (RDL):
- Count, owners, access mapping, and refresh logs (if using Paginated Reports)
- Embedded Reports or Service Principal Use:
- Check for reports used in embedding scenarios (e.g., external portals)
- List Service Principals and what access they have
- Gateway Analysis:
- On-prem gateways, associated datasources, and admins
- Tenant Settings Snapshot:
- Export critical Power BI tenant settings (e.g., Export control, share externally, Publish to web etc.)
- Useful for auditing governance posture
- License Usage:
- List of Pro users not publishing or viewing reports (to optimize license cost)
- Sensitivity Labels & Data Classification:
- Which reports/datasets are labeled? Any missing?
- Audit Log Retention:
- Ensure important logs (activity, sharing, access) are being archived if M365 log retention is limited
- Datasets with Large Size or Long Refresh Duration:
- High-resource datasets can impact capacity , identify them early