Automatic refresh Power BI (desktop and/or online)

[karelstoel]

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!

[Anonymous · Accepted solution]

@karelstoel 

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

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

[v-luwang-msft · Accepted solution]

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.

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

[SanketBhagwat · Accepted solution]

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'.

[v-luwang-msft · Accepted solution]

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.

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

[Anonymous · Accepted solution]

@karelstoel 

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

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