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 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
v-venuppu , rohit1991 , MFelix
Hi,Regarding the powershell api calls for the below, is there more detail into how/the api's etc?
"What you can get:
- Report names & count >> Get-PowerBIReport -Scope Organization
- Workspace names, count, members >> Get-PowerBIWorkspace -All + Get-PowerBIWorkspaceUser
- Active/inactive workspaces >> Use last activity or refresh date
- Active users (names) >> From Get-PowerBIActivityEvent
- Inactive users >> Subtract from full user list (request from IT)
- Report usage (including link views) >> Tracked in activity logs
- Report refresh rate & last refreshed >> Get-PowerBIDataset + Get-PowerBIRefreshHistory
- Failed refreshes >> Check refresh status
- Data size per workspace >> Admin API or Premium Metrics App
- Personal workspaces >> Get-PowerBIWorkspace -Scope Individual
- Data size per workspace or tenant:
You can get dataset sizes using Get-PowerBIDataset and some metadata columns (especially if you’re on Premium).
Or just ask IT to help with the Premium Capacity Metrics App if you have Premium. - Personal workspaces with reports:
Use Get-PowerBIWorkspace -Scope Individual and check which ones contain reports."
