cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aamir_khan
Advocate V
Advocate V

Cannot see Automatic page refresh in the Power BI desktop.

Cannot see Automatic page refresh in the Power BI desktop.

 

I have enable the serviceI have enable the serviceCannot see Automatic page refresh in the Power BICannot see Automatic page refresh in the Power BICannot see Automatic page refresh in the Power BICannot see Automatic page refresh in the Power BI

11 REPLIES 11
pezeta
New Member

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

 

Regards

Pedro Zambrano Bojorquez

Tecnológico de Chihuahua, Mexico

Omitsky
Frequent Visitor

Facing the same issue too.No automatic refresh option available under options

Omitsky_0-1600497464442.png

 

v-alq-msft
Community Support
Community Support

Hi, @Aamir_khan 

 

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. 

 

Best Regards

Allan

v-alq-msft
Community Support
Community Support

Hi, @Aamir_khan 

 

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.

 

c1.png

There are some considerations and limitations. For further information, please refer to the official document .

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I have check everything but no use.. My other colleague is facing same problem



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.

 

Regards

Rajendra

judspud
Solution Supplier
Solution Supplier

Hi @Aamir_khan 

 

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

 

Thanks,

George

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

Hi @Aamir_khan 

 

What data connection do you have?

 

Automatic refresh is for use with Direct Query data connections

 

Thanks,

George

Omitsky
Frequent Visitor

If its not Direct Querry that means you cant  automatically refresh your data ?

I am using Web 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

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.

Top Solution Authors
Top Kudoed Authors