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. 

nickyvv's avatar
nickyvv
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago
If you use the DirectQuery option to connect to the table in SQL (where new data is imported every 5 min), the developer will always have the latest view on the data. DirectQuery will not import any data into Power BI, instead it will fire a query at the source database whenever a report or dashboard is opened.
There are a few limitation, so please have a look at: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Anonymous's avatar
Anonymous
Not applicable
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.