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