Forum Discussion
Data doesn't get updated by direct query report
Super Useror you have to press the refresh button.
Whilst there is a new feature for the reports to auto refresh if you are using Power BI Pro it only updates every 30 minutes.
GilbertQ Does data get update if I click the refresh button on the report? I thought the 'refresh' button on the report only refresh the visualation on the report which doesn't refresh my data. Anyway it works. Thanks for the advise. However when I interact with my report, my data doesn't get updated. Why this? Or which kind of interaction can refresh my data in this case?
- GilbertQHI there
Can you confirm that there is data being updated in the underlying Azure SQL DB?
Also are there any filters on your page or visuals which could be limiting the data from being updated?GilbertQ Thanks for reply. I do confirmed that underlying data in my Azure SQL DB is updated.(we use a sync-group to synconaized data from local SQL DB to Azure SQL DB). I check the log from Sync-group. My data is successfully updated every time. Secondly, There only a date filter that filtered my visualazition. That is used for filter out our today data. I don't think any of these factors caused my data not being freshed on the report.
If you need to "auto refresh" you can use the Revolver app in Chrome. We do this for reports that are displayed on a large screen in our operations center.
https://chrome.google.com/webstore/detail/revolver-tabs/dlknooajieciikpedpldejhhijacnbda?hl=en
Hi Anonymous
Does this do that trick? How? I am pretty interested on this. Is this rotating my tabs and refresh my page every rotation? So I have to keep my Chrome open to get the auto-refreshing?
Yes, you would need to keep it open to refresh.