Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Power BI Refresh Frequency

I hope to display my Power BI report on a screen and refresh it very frequently (e.g. every 5 mins). My report connects to the SQL Server Database (on-premises gateway, "Import" method) and my account is with a Pro license (I do not plan to upgrade to Premium), I'm currently refresh my report 8 times per day.


I heard different opinions, some say even the premium lisence can only refresh 48 times per day, some say the "Automatic Page Refresh" enables refreshing at every 1 second (refrence: Real-Time Analytics in Power BI (


Can Power BI achieve a real-time refreshing with Pro lisence?


Thank you in advance!


This specific sub forum is for on premises Power BI Report Server topics. Note that on-premises the number report dataset refreshes in not controlled by licensing. From your question, you seem to imply this is hosted in the power bi service. 


A pro license there gives you rights to share content with other pro licensed users. Premium licensing is meant for broad distribution to other non-licensed report consumers. By refreshing, you can refres the report itself as often as desired, but the underlying dataset can be refreshed per the license limitations. For Pro that is 8 times per day. For Premium (and Premium Per User) that is 48 per day. 


If you need more up to date data, consider using direct query, where report views will re-query on-demand (provided you accept some additional perf latency due to connection time and underlying database).

Hello Jon-Heide,

Thank you for the answer. Yes, I have experimented DirectQuery mode and the Automatic Page Refresh function. In DirectQuery it did refresh more frequently than Import, but another problem happened.

I set the Automatic Page Refresh of my report to "1 Minute" but when I publish this report to Power BI service, the most frequent refresh interval for my dataset is every 15 minutes. In case that I wish my report to refresh more frequently, is there a solution?


Thank you!


David Meng

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.