Cannot see Automatic page refresh in the Power BI desktop.
I recommend reading the following note at https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages, it clearly explains the problem. Indeed it can only be used with DirectQuery Connection the option Automatic page refresh
Pedro Zambrano Bojorquez
Tecnológico de Chihuahua, Mexico
I wonder if the version of Power BI Desktop is the latest one. It works properly with the latest version in my computer. And which connect mode you are using. It works only for DirectQuery instead of 'import' or 'live connection'. From the above reply, you said you are using Web. However, Web is not a connect mode. For further information, please refer to the official document .
Here are the supported Power BI data source . It may help.
The automatic page refresh (APR) feature in Power BI lets your active report page query for new data, at a pre-defined cadence, for DirectQuery sources.
Firstly, you need to Go to File > Options and settings then select Options, and select Preview features from the left pane. Enable the feature by selecting the checkbox beside Automatic page refresh.
To use automatic page refresh, select the report page for which you want to enable refresh. In the Visualizations pane, select the Formatting icon (a paint roller) and find Page refresh near the bottom of the pane.
There are some considerations and limitations. For further information, please refer to the official document .
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
As just checked , one of my collegue using 2019 version December. in that i am able to see Automatic refresh option.
In 2020 Feb Version, though we have checked in preview feature, that automatic refresh option is not available in format pane.
I think we have to report this feature missing informaiton to MS support team.
Have you restarted PowerBI Desktop since enabling the preview feature?
Also, the page refresh is under the format section rather than fields. Click the paint roller icon and it should be at the bottom
Hope this helps
After enable the feature I have restarted the power bi but Cannot see Automatic page refresh in the Power BI desktop anywher I have check that
What data connection do you have?
Automatic refresh is for use with Direct Query data connections
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.