Forum Discussion
Disable Dashboard Refresh
Hi,
I dont want my Dashboards to refresh whenever a new Dataset is Published.
I want my dashboards to be static at the point when I pin them and to ignore any subsequent data refreshes.
Is this possible?
4 Replies
SeanL that seems to go against the entire point of refreshing the dataset. If you need to show some values at a certain point in time in the past it's probably best to use time intelligence functions to write a measure that specifies that point in time. What sort of data are you trying to show in this way?
I do think there are a number of reasons to disable dashboard refresh, one is that I need to futher edit measures/columns and a refresh may take, say 10 minutes, which may potentially hit productivity.
Actually I really prefer to have full control of refresh when I'm the DESIGNER, not the user. Idealy Power BI would have a manual mode when you are editing and it won't refresh at all until I click the refresh button. So if I load a new dataset and forget to hit the refresh button I simply can't use it, which is so much better than it refreshes every time some tiny new things/modifications have been made. But I don't think that feature will ever appear...another option is the ability to disable all visualization refresh.
One way to achieve this with equal visualization is to use Python + Dash but apparently it's out of touch of most people.
Hi SeanL,
Which data source are your using? If you want dashboards to be static at the point, the best choice for is to create a snapshot at that point. And get data from that snapshot.
A database snapshot is a read-only, static view of a SQL Server database (the source database). The database snapshot is transactionally consistent with the source database as of the moment of the snapshot's creation.
Reference
https://msdn.microsoft.com/en-us/library/ms175158.aspxRegards,
Charlie Liao
