Forum Discussion
Workspace usge metrics report not refreshing
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!
Resolver IIIYou 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!
- m-colbert
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.
I saw the PBI data refresh action but I am not sure what can be the action trigger here? Many thanks!