Forum Discussion
sql date refresh frequency settings
Hi, I wanted to make sure I'm not missing something on options of frequency for sql data source refreshes. My understanding is that with direct query, it queries the database in realtime as user in...
Hi lgroger ,
You are correct that everytime you are modifying a report or dashboard that a Direct Query will query the dataset. This is the good/bad of Direct Query - you are not storing/caching any data locally BUT, that means that with every change, the system goes back and re-queries the data. There is no option that I am aware of that would stop this behaviour as this is the designed method. If at all possible, you can change to Import and that would stop the constant re-query aspect of the report.....but, you may intentionally be on Direct Query for other reasons.
