HI,
I created a file with a connection to an Database->Analysis Service. the file is saved on One Drive.
On the connection properties I have seen, that there are several option for an auto refresh, as such "refreshing every ..." minutes.
Can someone tell me, if
- I can get the data refreshed once a day, if I set up 1440 minutes?
- the data gets refreshed in the background, while the file is closed?
BTW, I can see a check box for "Enable background refresh", but it is greyed out. Does anyone know, why this is not an option?
Thank you.
best regards, Christoph
Hi Christoph,
The file will only refresh when it's open. In which case you might be best to set it to refresh upon opening.
Mynda