Power Platform Community Forum Thread Details

We are working on creating Power BI dashboards utilizing data stored in files on SharePoint. Currently our developer has it set up that the datasets are refreshed when a file is created or modified and we are running into throttling issues due to the number of files and updates daily.

We only need to have our data refreshed for our dashboards once a day - so is there a way that I can change the trigger for the flow to be a recurrence of 10 pm nightly? Is there something additional that would to be done or would changing that trigger work?

Categories:

Using flows

This is a better approach:

Go to your dataset in the Power BI Service → Settings → Scheduled refresh.

Enable the automatic refresh to run once daily (for example, at 10 PM).

Power BI will then connect directly to the SharePoint data source, no Power Automate needed.

To your question:

Yes, if you prefer to use Power Automate, your setup is technically correct.

Using a Recurrence trigger (for example, running once daily at 10 PM) together with the “Refresh a dataset” action will successfully refresh your Power BI dataset once a day and avoid throttling issues. (Screenshot looks correct)

However, keep in mind that this approach adds an extra layer that isn’t really necessary.

Power BI already supports scheduled refreshes directly in the service, which is simpler, more stable, and officially recommended by Microsoft.