In Power BI Service, there are only 2 options to refresh the data, which is weekly or daily but for some datasets, it is more convenient for a monthly refresh or every time I upload a file in sharepoint or in onedrive for instance.
In order to be able to do it, I will use Power Automate Cloud. If you don’t have it, you will need to install it. There are 2 versions:
For more information: Microsoft Power Automate.
Once installed it, I can go directly to Power Automate Cloud or from Power BI Service:
To create the monthly refresh, I will click on:
Now, l will create another flow but in this one, I will request to refresh my dataset every time I will upload a file in the cloud. For my example, I will use sharepoint.
I will click again on “+ create” and this time, I will select “automated cloud flow”.
In the popup window, I give a name and on the “search” field, I put “sharepoint” to see all options. For my example, I select “when an item or a file is modified SharePoint” then click on “create”.
In the next popup, fill again all fields then click on “+ new step”. From here, the process is the same as the first option so just follow the same step.
NOTE:
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...