Forum Discussion
Solved
Problem refreshing Usage Metrics Report
Hi there I have found this website to remove Usage Metrics Reports from one specific workspace: Datasets - Delete Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs ...
Hi webchris ,
You can use Postman to call rest api.
Postman is an API platform for building and using APIs. Postman simplifies each step of the API lifecycle and streamlines collaboration so you can create better APIs—faster.
Postman related information:
Web version of Postman:
Download Postman：
https://www.postman.com/downloads/
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Dom I am very sorry, but I cannot recall the solution any more.
Hi Chris,
It took me a while to get back to this topic. Anyway, I used a manual approach because I just needed to delete one report.
# Connect to Power BI Service, enter your credentials manually
Connect-PowerBIServiceAccount -Credential (Get-Credential)
# Get a specific workspace by name. You don't need the "-Scope Organization" filter, you just need admins permission for the specific workspace
Get-PowerBIWorkspace | select-object -Property Id, Name, Type | where Type -eq "Workspace" | where Name -eq "Workspace Name"
# Alternative #1: search for the exact name
Get-PowerBIReport -WorkspaceId [GUID] | select-object -Property Id, Name, WebUrl | where Name -eq "Usage Metrics Report"
# Alternative #2: search for a report which contains a string
Get-PowerBIReport -WorkspaceId [GUID] | select-object -Property Id, Name, WebUrl | where Name -like "*Usage Metrics Report"
# Delete the report using the ID of the workspace and report you extracted in the steps before
Remove-PowerBIReport -Id [GUID] -WorkspaceId [GUID]
# Check if the was deleted successfully
Get-PowerBIReport -WorkspaceId [GUID] | select-object -Property Id, Name, WebUrl | where Name -like "*Usage Metrics Report"
# Disconnect from Power BI Service
Disconnect-PowerBIServiceAccount
That solved it.