Forum Discussion

_BI_'s avatar
_BI_
New Member
3 years ago
Solved

Power BI - Schedule refresh

Hi,   I want to refresh the on-prem data in Power BI(Pro) service using "Schedule refresh" more than 8 times a day. Is there any way to achieve that.
Need Help
  • Manokamna's avatar
    Manokamna
    3 years ago

    By default, Power BI allows up to 8 scheduled refreshes per day for datasets in Power BI Pro. However, if you need to refresh your data more frequently than that, you can consider upgrading to Power BI Premium or Power BI Embedded, which provide more options for refreshing your data.

    With Power BI Premium, you can set up refresh schedules as frequent as every 15 minutes or even trigger refreshes in real-time using DirectQuery or Live Connection.

    Alternatively, you can also consider using Power Automate (formerly Microsoft Flow) to refresh your data more frequently. You can create a flow that refreshes your dataset at the desired frequency and triggers it using a timer or other trigger. Note that this approach requires a separate license for Power Automate.

carlycarlylea's avatar
carlycarlylea
New Member
1 year ago

I have Premium and can only see increments of 30 minutes, so I did that. Then, I also set up Power Automate to do the ones every 15 and 45 minutes within the hour.  I guess you can do it all in Power Automate if needed and set up an email if you have any failures. I like the emails and the error logs from Power BI, so I will stick with half/half. Please let me know if there is another way to do this in just Power Bi.