Easy Tech TutsHow to Auto Refresh a Page in Power BI Desktop Easily 2026
By Impran M N
Manually clicking refresh all day isn't practical for dashboards tracking live metrics like IoT sensors, stock prices, or warehouse activity. Power BI's automatic page refresh feature updates your canvas on a set interval without user interaction, as long as your connection mode supports it. Here's how to enable it correctly.
01Switch your connection to DirectQuery
Automatic page refresh requires a DirectQuery or Microsoft Fabric Direct Lake connection mode rather than standard Import mode, so confirm your data source is configured this way first.
02Open the page-level formatting options
Select the specific report page you want to auto-refresh and open its formatting pane to find the refresh settings.
03Set your refresh interval
Choose a duration for how frequently the page should refresh, balancing responsiveness against the load placed on your underlying data source.
04Manage query limits
Be mindful of how resource-intensive your refresh queries are, since overly frequent refreshes on complex queries can strain your data source.
05Publish your live dashboard
Publish the report to the Power BI Service so the automatic refresh continues running for anyone viewing the shared dashboard.
Frequently asked questions
Does automatic page refresh work with Import mode?
No, it requires DirectQuery or Microsoft Fabric Direct Lake connection modes rather than standard Import mode.
How short can I set the refresh interval?
Available minimum intervals depend on your license tier, with shorter intervals generally reserved for premium capacities.
Will frequent refreshing slow down my data source?
It can, especially with complex queries, so it's worth managing your refresh frequency against your source system's capacity.
Can I set different refresh rates for different pages?
Yes, automatic page refresh is configured at the individual page level, so different pages in the same report can have different intervals.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
