Auto Refresh With Direct Query In Seconds

[Kent_Sam_zhao]

Hi All,

We are working on one Power BI using the Direct Query via SQL Server. 

I works on desktop in mins or seconds level, but after we publish it to the Power BI Service, it only supports the mim level on 15 min, I roughly search the Posts on the Community without lucky result.

Would some one please helps on this ? 

Thanks,

Sam

[v-binbinyu-msft · Accepted solution]

Hi @Kent_Sam_zhao ,

Automatic page refresh works at a report page level, and allows report authors to set a refresh interval for visuals in a page that is only active when the page is being consumed. Automatic page refresh is only available for DirectQuery data sources. The minimum refresh interval depends on which type of workspace the report is published in, and the capacity admin settings for Premium workspaces and embedded workspaces.

Power BI Desktop has no restrictions for refresh intervals and can be as frequent as every second. However, when reports are published to the Power BI service, certain restrictions apply.

Shared workspaces. For regular workspaces (workspaces that aren't part of a Premium capacity), automatic page refresh has a minimum interval of 30 minutes (the lowest interval allowed). Change detection refresh type is not available in shared capacities.

Premium workspaces. The availability of automatic page refresh in Premium workspaces (both for fixed interval and change detection) depends on the workload settings your Premium administrator has set up for the Power BI Premium capacity. There are two variables that might affect your ability to set up automatic page refresh:

• Feature on/off. If your capacity administrator has disabled the feature, you won't be able to set up any type of page refresh in your published report. Fixed interval and change detection can be turned on and off separately.

• Minimum refresh interval. When enabling automatic page refresh for a fixed interval, your capacity administrator needs to set up a minimum refresh interval (the default value is five minutes). If your interval is lower than the minimum, the Power BI service overrides your interval to respect the minimum interval set by your capacity administrator.

• Minimum execution interval. When enabling change detection, your capacity administrator needs to set up a minimum execution interval (default value is five seconds). If your interval is lower than the minimum, the Power BI service overrides your interval to respect the minimum interval set by your capacity administrator.

For more details, you can read related document: Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kent_Sam_zhao]

I found one solution which use the Auto Refresh Extension in Chroms Browswer, Is there any friend tried out? Just think the web page refresh is not the data set refresh which may not grab the real time data. Cause the environment constaint, I can not try, hope some expert give some highlight.

Thanks