Forum Discussion
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 to be refreshed on daily basis but since this month the usage data is not refreshed anymore. I checked the datasets setting and looks like there is an error occured related to credentials when there was refresh intent for the usage metrics report (And since 7 Jun, the refresh intent stopped). I updated the data credentials section and on the next day when I checked the usage report, it was still not refreshed.... Could someone please help advise? Details screenshot pls see below (I hid the sensitive information). Thank you in advance!
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!
7 Replies
m-colbertResolver III
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!
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
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.
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!
that doesnt' work here
