Forum Discussion

webchris's avatar
webchris
Advocate III
4 years ago
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

 

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...

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.507513807.1634529441-551232759.1634529441 

    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.

  • webchris's avatar
    webchris
    Advocate III
    4 years ago

    Hi Liu Yang, thanks for your support. 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

    • webchris's avatar
      webchris
      Advocate III
      2 years ago

      Hi Dom I am very sorry, but I cannot recall the solution any more.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.