Want to auto-update screen every minute, won't do it.

[jedwards_CSS]

So we have a Power BI dashboard that we want to update every minute.  It's a Direct Query, and we've set it to update every minute.  It updates every 5 minutes.  When we look at the refresh setting we see what's below --

This appears to say that the admin has set the minimum refresh interval to one second, so we should be able to set this at one minute.  But it updates every five minutes in spite of us setting it to 1.

Question -- are we missing another setting somewhere else in the system?

[Anonymous]

Hi @jedwards_CSS 

Thanks for the reply from @collinq , please allow me to provide another insight:

Here are my tests for your reference.

In my test I am using Direct Query connection mode to connect to SQL server.

Then I configured Auto page refresh for one minute intervals.

Normal Refresh

My advice for now is to check that you are logged into your account.

If I'm not logged in to my account then it looks like this:

For more details about Auto page refresh, you can read related document link:

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

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

[jedwards_CSS]

So that "Admin Interval 1 Second" thing essentially means nothing?  That is not referring to the admin setting for the minimum interval?

[jedwards_CSS]

FYI, our admin set the refresh to 1 second, we set the refresh to one minute.  Refresh remains set to five minutes.  None of this helps, there must be another place where this needs to be set.

[collinq]

HI @jedwards_CSS ,

You are correct that the "refresh this page every" setting is the controlling setting.  This could be in two places - the desktop file (which you apparently have set to 1 minute?) and in the Premium Capacity workload configuration.  The instructions for the admin are at this site:  How to configure workloads in Power BI Premium - Power BI | Microsoft Learn

But, be sure that you have the page refresh setup in the desktop file to the 1 minute as well.

[jedwards_CSS]

FYI, our admin set the refresh to 1 second, we set the refresh to one minute.  Refresh remains set to five minutes.  None of this helps, there must be another place where this needs to be set.

[jedwards_CSS]

So that "Admin Interval 1 Second" thing essentially means nothing?  That is not referring to the admin setting for the minimum interval?