How to Auto Refresh of Power BI Report?

[HersonD]

Hi, 

I want my report to be realtime as much as possible so I have set up a triggered flow using power automate to refresh my power BI report. However, after 8 refreshes, the flow stops working and I have to manually refresh my report again. 

Is there a way I can achieve my goal? 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure where your source is stored, but one of ways you can try to implement is, using direct query mode.

DirectQuery in Power BI - Power BI | Microsoft Learn

[rajendraongole1 · Accepted solution]

Hi @HersonD -The behavior you're experiencing, where Power Automate stops triggering after 8 refreshes, is likely due to Power BI's dataset refresh limits

Power BI Pro --> 8 scheduled refreshes per day are allowed.

• You can use On-Demand (manual) refreshes, but these also count towards the limit.
• Power BI Premium/Embedded--> 48 scheduled refreshes per day are allowed (which translates to roughly one refresh every 30 minutes).You can still use On-Demand refreshes via Power Automate or other triggers without hitting the refresh cap as quickly.

Since you are using Power BI Embedded (based on your previous message), you should have access to more refreshes, but still, Power Automate triggers may run into these limitations. 

Instead of relying on scheduled refreshes, DirectQuery allows Power BI to pull data directly from the data source at the time of report interaction. This ensures the latest data is always shown without needing frequent refreshes.

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn

https://community.powerbi.com/t5/Desktop/Automatic-Data-Refresh-How-to-do-it/td-p/2415521

[Kedar_Pande · Accepted solution]

@HersonD 

Consider these options:

1. Switch to DirectQuery mode if your data source supports it. This allows Power BI to query data directly, providing real-time updates without manual refreshes.
2. Turn on Automatic Page Refresh in the Format pane of your report. Set it to refresh at a fixed interval (minimum is one second) for real-time visual updates.
3. Consider using Push Datasets to send data directly into Power BI via the REST API, allowing for real-time updates without relying on scheduled refreshes.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[rajendraongole1 · Accepted solution]

Hi @HersonD -The behavior you're experiencing, where Power Automate stops triggering after 8 refreshes, is likely due to Power BI's dataset refresh limits

Power BI Pro --> 8 scheduled refreshes per day are allowed.

• You can use On-Demand (manual) refreshes, but these also count towards the limit.
• Power BI Premium/Embedded--> 48 scheduled refreshes per day are allowed (which translates to roughly one refresh every 30 minutes).You can still use On-Demand refreshes via Power Automate or other triggers without hitting the refresh cap as quickly.

Since you are using Power BI Embedded (based on your previous message), you should have access to more refreshes, but still, Power Automate triggers may run into these limitations. 

Instead of relying on scheduled refreshes, DirectQuery allows Power BI to pull data directly from the data source at the time of report interaction. This ensures the latest data is always shown without needing frequent refreshes.

Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn

https://community.powerbi.com/t5/Desktop/Automatic-Data-Refresh-How-to-do-it/td-p/2415521

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure where your source is stored, but one of ways you can try to implement is, using direct query mode.

DirectQuery in Power BI - Power BI | Microsoft Learn