Forum Discussion

Bodo's avatar
Bodo
Helper I
2 years ago
Solved

RealTime report with Direct Query and refresh rate 1 minute

I want to create a real-time report in Power BI that shows a list of the next tasks of a team. I have created a Direct Query to a Postgres DB and set the "Page refresh" to 1 minute (see sceen sh...
Need Help
Tutorial Requests
  • aj1973's avatar
    aj1973
    2 years ago

    I don't think a PPU can change the settings of a WS as the Tenant Admin

     

  • Bodo's avatar
    Bodo
    2 years ago

    OK, the tenant admin need to set the minimum refresh rate to 1 minute in the admin portal/premium per user page.  Then the reports can be refreshed every minute automatically:

     

     

jedwards_CSS's avatar
jedwards_CSS
Advocate II
2 years ago

Hang on, finally found it.  I don't have sufficient access to modify that setting.  I see this in the particular Power BI page I'm looking to speed up --

 

Even with that set up, the page refuses to move to refresh every minute.  It refreshes every five.

 

Question -- with what appears above, should a developer be able to set a page to refresh every minute?  Does the "Admin interval" mean that once a minute is ok?

Bodo's avatar
Bodo
Helper I
2 years ago

Hi jedwards_CSS ,

This is a premium feature (it's configurable in the "Premium Per User" section).
So you need to upload your report into a premium workspace (the workspace is flagged with a diamant), otherwise the report will not be refreshed.

 

Additional to that you need to set the "Page refresh" to 1 minute for every page.

Hope this helps
Bodo