I have a dataset with a direct connection using DirectQuery and would like to schedule cache refresh so that the dataset doesn't update everytime a user interacts with it. However, I cannot set the refresh frequency, as it is greyed out.
Thank you for your reply. The data gateway was insalled and running but the field was still greyed out. However today I can set the refresh schedule for some reason. Maybe I just had to give it some time.