Forum Discussion
Full Comprehensive PowerBI Service Audit
- 1 year ago
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 ,
If you don't have a fabric capacity then you can check the Monitor Report Usage metrics
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics
rohit1991 , MFelix Thank You
rohit1991 1. Refresh Failures Summary, 5. Gateway Analysis: and 7. License Usage:
Can you please provide the powershell code + api examples to all these i require, and how
MFelix its more a once-off or every 2 years exercise, so i dont really want to be developing a report. Also this works for a specific dataset/report only, it does not give me the big picture of things i am not aware of, like personal workspaces, the users uasge etc