January 31, 2019
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?
best regards, Christoph