DirectQuery refresh set to 15 minutes, but still refreshes in 2 hours

[andhawan]

Hi All,

I have a direct query setup to SQL Server. I have set the refresh cache option to 15 minutes. Still my data refreshes only after 2 hours. The query also executes in less than 20 seconds and the dataset is small too. Can anyone help?

Scheduled cache refresh is set to 15 Minutes. 

Refresh history shows refresh every 2 hours.

[v-yuta-msft]

Hi andhawan,

Could you post some screenshot of your cache refresh log and your cache refresh configuration?

Regards,

Jimmy Tao

[andhawan]