Forum Discussion

Jmccoy's avatar
Jmccoy
Icon for Helper II rankHelper II
6 years ago
Solved

Refresh and display every 5 min

I am putting into visuals the health of our servers for my developer to monitor without having to look through tables in SQL. The table in sql is set to pull in data every 5 minutes and update the ta...
Show and Tell
Tips and Tricks
  • Icey's avatar
    Icey
    6 years ago

    Hi Jmccoy ,

     

    When you use Direct Query option to connect to SQL Server, you could try to set Automatic Page Refresh.

    Please pay attention to the minimum refresh interval:

    Storage mode Dedicated capacity Shared capacity
    DirectQuery Supported: Yes
    Minimum refresh interval: 1 second
    Capacity admin override: Yes    		 Supported: Yes
    Minimum refresh interval: 30 minutes
    Capacity admin override: No
    Import Supported: No
    Minimum refresh interval: N/A
    Capacity admin override: N/A    		 Supported: No
    Minimum refresh interval: N/A
    Capacity admin override: N/A
    Mixed mode (DirectQuery + other data sources) Supported: Yes
    Minimum refresh interval: 1 second
    Capacity admin override: Yes    		 Supported: Yes
    Minimum refresh interval: 30 minutes
    Capacity admin override: No
    Live connect AS Supported: No
    Minimum refresh interval: N/A
    Capacity admin override: N/A    		 Supported: No
    Minimum refresh interval: N/A
    Capacity admin override: N/A
    Live connect PBI Supported: No
    Minimum refresh interval: N/A
    Capacity admin override: N/A    		 Supported: No
    Minimum refresh interval: N/A
    Capacity admin override: N/A

     

    If the report is in a Premium workspace / Dedicated capacity, you can refresh report page every 5 minutes.

     

    If not, try to use Auto Refresh PowerBI Report extension.

     

     

    Best Regards,

    Icey

     

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

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Jmccoy,

     

    In addition to what nickyvv explained, I'd look at a browser extension to automatically update your browser window for an unattended machine. This blog lists a few options for different browsers.

     

    The automatic page refresh Icey mentioned, will only work with Dedicated Capacity. I couldn't deduce from your explanation if this is the case. 

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Jmccoy ,

 

When you use Direct Query option to connect to SQL Server, you could try to set Automatic Page Refresh.

Please pay attention to the minimum refresh interval:

Storage mode Dedicated capacity Shared capacity
DirectQuery Supported: Yes
Minimum refresh interval: 1 second
Capacity admin override: Yes		 Supported: Yes
Minimum refresh interval: 30 minutes
Capacity admin override: No
Import Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A		 Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Mixed mode (DirectQuery + other data sources) Supported: Yes
Minimum refresh interval: 1 second
Capacity admin override: Yes		 Supported: Yes
Minimum refresh interval: 30 minutes
Capacity admin override: No
Live connect AS Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A		 Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A
Live connect PBI Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A		 Supported: No
Minimum refresh interval: N/A
Capacity admin override: N/A

 

If the report is in a Premium workspace / Dedicated capacity, you can refresh report page every 5 minutes.

 

If not, try to use Auto Refresh PowerBI Report extension.

 

 

Best Regards,

Icey

 

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