Forum Discussion

WencyREN's avatar
WencyREN
Frequent Visitor
4 years ago
Solved

Workspace usge metrics report not refreshing

Dear, I have a premium workspace with several reports published on it, and we have been using the PBI auto-generated usage metrics report to capture each report's usage, the report usage was supposed...
Need Help
  • m-colbert's avatar
    m-colbert
    4 years ago

    WencyREN 

     

    Create a flow with a trigger that is recurrence, meaning on a schedule, se the frequency, then use the Power BI action of refresh dataset.

     

    Start by creating a scheduled cloud flow 

     

    Enter a name for your flow and set the time to refresh

     

    This gives you the trigger, than add your refresh action as the next step, 

     

    Select the workspace, the dataset will be named as shown, you will need one for each workspace that you want to refresh metrics for,

     

    Hope this helps!

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have the same issue.  The usage metrics report refresh was paused by the system due to multiple refresh failures after the original dataset owner left the company.  I have changed the credentials to myself (Admin), but there is no button to restart the refreshes and it's not happening automatically.  

 

 

  • m-colbert's avatar
    m-colbert
    Icon for Resolver III rankResolver III
    4 years ago

    You can easily set these datasets to refresh using Power Automate. I was refreshing each workspace's usage metrics report daily. Works like a charm. And Power BI is not a premoum connecotr so no extra licenses needed. Since add a recurring trigger and use the refresh a dataset action.

    • WencyREN's avatar
      WencyREN
      Frequent Visitor
      4 years ago

      Thank you so much for your reply! Is it possible for you to share few sample screenshots/explain a bit more further where/how to start setting a workspace usage metrics dataset refresh with Power automate? I am quite new on this one, thanks!

      • m-colbert's avatar
        m-colbert
        Icon for Resolver III rankResolver III
        4 years ago

        Well, there's a lot to unpack if you aren't familiar with Power Automate at all, but basically you can create a new flow on a recurring schedule, select the time of day you want the refresh to run. Then add a dataset refresh action form the Power BI connector, you will be able to select any workspace and dataset you have access to. The Usage Metrics Report dataset does not show inthe service when browsing the datasets, but will be included in the dropdown.

         

        This is a bit old and is based on a file being updated, but gives you the gist of the process. 

        Refresh your Power BI dataset using Microsoft Flow | Microsoft Power BI Blog | Microsoft Power BI

         

        Good luck.