Notifications
Clear all
Power Pivot
2
Posts
2
Users
0
Reactions
185
Views
Topic starter
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
Posted : 27/08/2022 6:54 am
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
Posted : 29/08/2022 1:05 am
