Forum Discussion

Zakaria15's avatar
Zakaria15
New Member
8 years ago

Auto Refresh each minute

Hi,

This is the first time I post in this forum, hope it's the right one.

 

we're working on a project that requires synoptic panel. We're connected to a sql server database with DirectQuery. Each minute we have a new row inserted into the database. When I click refresh, I can see the newly inserted data, but the customer require to see the current data each minute without any interaction with the report and without clicking refresh. 

 

The report is autorefreshed each 15 minutes, but we need it to refresh each minute. Tab auto refresh extension of google chrome was not accepted as a solution by the customer. 

 

Does the Power BI premium licence gave us the ability to autorefresh each minute ? Is there a solution to make our report autorefresh each minute?

We're stuck, any help would be appreciated.

 

7 Replies

  • Hi,

    This is the first time I post in this forum, hope it's the right one.

     

    we're working on a project that requires synoptic panel. We're connected to a sql server database with DirectQuery. Each minute we have a new row inserted into the database. When I click refresh, I can see the newly inserted data, but the customer require to see the current data each minute without any interaction with the report and without clicking refresh. 

     

    The report is autorefreshed each 15 minutes, but we need it to refresh each minute. Tab auto refresh extension of google chrome was not accepted as a solution by the customer. 

     

    Does the Power BI premium licence gave us the ability to autorefresh each minute ? Is there a solution to make our report autorefresh each minute?

    We're stuck, any help would be appreciated.

    • vikrant7677's avatar
      vikrant7677
      Regular Visitor

      since the frequency of your refresh is too spontaneous, in your case, it is better to go for real time streaming dataset(API calls) rather than refreshing it every minute.

    • vikrant7677's avatar
      vikrant7677
      Regular Visitor

      since the frequency of your refresh is too spontaneous, in your case, it is better to go for real time streaming dataset(API calls) rather than refreshing it every minute.

      • Zakaria15's avatar
        Zakaria15
        New Member

        Thank's for your reply,

         

        As I said we are using a custom visual, and the real streaming dataset allows only 5 type of charts so it's not very useful in our case.