Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
webchris
Helper IV
Helper IV

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

 

Unfortunately, I do not know how to call the mentioned "DELETE https://...." API. Do I need a tool, a website? Why is this not described in this "support" website? 

 

Please help, thanks...

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

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: 

https://www.postman.com/ 

Web version of Postman: 

https://identity.getpostman.com/signup?continue=https%3A%2F%2Fgo.postman.co%2Fbuild&_ga=2.103938564.... 

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.

View solution in original post

5 REPLIES 5
DomPower
Regular Visitor

Hi @webchris ,

 

Can you tell me how you solved it using PowerShell. I'm facing the same issue. Unfortunately, the dataset of the Usage Metrics Report is not accessible using the GUI. 

 

Thanks a lot.

 

Cheers,

Dom

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.
webchris
Helper IV
Helper IV

Hi Liu Yang, thanks for your support. 

MS Support helped me to solve my issue through PowerShell using API.

v-yangliu-msft
Community Support
Community Support

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: 

https://www.postman.com/ 

Web version of Postman: 

https://identity.getpostman.com/signup?continue=https%3A%2F%2Fgo.postman.co%2Fbuild&_ga=2.103938564.... 

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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors