cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karelstoel
Frequent Visitor

Automatic refresh Power BI (desktop and/or online)

Goodmorning! I would like to make an automatic refresh every two hours. When I take a look online I see at others the option 'automatic page refresh' (see first picture below) but at my own options I don't see this possibility (see second picture below). 

 

Does anyone can help me with this, do I have to arrange this in Power BI desktop or Power BI Online? And what steps do I have to take?

 

Thanks in advance!

 

Options - 1.pngOptions - 2.png

3 ACCEPTED SOLUTIONS
ranga_88
Helper I
Helper I

@karelstoel 

 

go to power bi service (https://app.powerbi.com/)

select the workspace then select the dataset we have a option schedule refresh icon

View solution in original post

v-luwang-msft
Community Support
Community Support

Hi @karelstoel ,

To use automatic page refresh in Power BI Desktop, select the report page for which you want to enable automatic page refresh. In the Visualizations pane, select the Formatting button (a paint roller) and find the Page refresh section near the bottom of the pane.

vluwangmsft_1-1637912159710.png

 

Turns page refresh on or off.

  1. Refresh type
  2. Inputs and information (depending on refresh type)

The Page refresh card will only be available if you are connected to a DirectQuery source. To enable automatic page refresh the toggle needs to be on the On position. The inputs needed and information provided will depend on the refresh type selected.

There are a few things to keep in mind when you use automatic page refresh in Power BI Desktop or in the Power BI service:

  • Import storage mode is not supported for automatic page refresh.
  • Composite models that have at least one DirectQuery data source are supported.
  • You can only have one change detection measure per dataset.
  • There can only be a maximum of 10 models with change detection measure in a Power BI tenant.

To learn more details ,refer:

Automatic page refresh in Power BI

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

SanketBhagwat
Continued Contributor
Continued Contributor

Hi @karelstoel .
Preview features are something which are under review or testing.
Automatic Page Refresh feature is no more under preview, so you won't be seeing that under that field.

Also Automatic page refresh isn't supported for Import mode.
It works only for DirectQuery mode or mixed mode(DirectQuery plus other data sources).

Regards,
Sanket 

 

If this post helps, then give it a 👍 and if it answers your question, then mark it as 'Accept as Solution'.

 

View solution in original post

3 REPLIES 3
SanketBhagwat
Continued Contributor
Continued Contributor

Hi @karelstoel .
Preview features are something which are under review or testing.
Automatic Page Refresh feature is no more under preview, so you won't be seeing that under that field.

Also Automatic page refresh isn't supported for Import mode.
It works only for DirectQuery mode or mixed mode(DirectQuery plus other data sources).

Regards,
Sanket 

 

If this post helps, then give it a 👍 and if it answers your question, then mark it as 'Accept as Solution'.

 

View solution in original post

v-luwang-msft
Community Support
Community Support

Hi @karelstoel ,

To use automatic page refresh in Power BI Desktop, select the report page for which you want to enable automatic page refresh. In the Visualizations pane, select the Formatting button (a paint roller) and find the Page refresh section near the bottom of the pane.

vluwangmsft_1-1637912159710.png

 

Turns page refresh on or off.

  1. Refresh type
  2. Inputs and information (depending on refresh type)

The Page refresh card will only be available if you are connected to a DirectQuery source. To enable automatic page refresh the toggle needs to be on the On position. The inputs needed and information provided will depend on the refresh type selected.

There are a few things to keep in mind when you use automatic page refresh in Power BI Desktop or in the Power BI service:

  • Import storage mode is not supported for automatic page refresh.
  • Composite models that have at least one DirectQuery data source are supported.
  • You can only have one change detection measure per dataset.
  • There can only be a maximum of 10 models with change detection measure in a Power BI tenant.

To learn more details ,refer:

Automatic page refresh in Power BI

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

ranga_88
Helper I
Helper I

@karelstoel 

 

go to power bi service (https://app.powerbi.com/)

select the workspace then select the dataset we have a option schedule refresh icon

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors