Forum Discussion
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
- Zakaria15New Member
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.- vikrant7677Regular 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.
- vikrant7677Regular 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.
- Zakaria15New 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.