Power BI Service Direct query refresh issue

[vamshikrishna89]

 Hi,

Need Help!!!

I have a sql query dataset built on Paas Server in Direct query mode. I enabled cache refresh for the query every 15 minutes and added getutcdate() field in the query so that every time I would get a refresh time. But the getutcdate() in sql is not getting updated even after cache refresh. And also cache is getting refreshed in 0 secounds, I am not sure if it is refreshing my data set.

Please help!!!

[v-diye-msft]

Hi @vamshikrishna89 

I figure there is something wrong with your SQL parameter. below 2 posts probably helps:

https://community.powerbi.com/t5/Desktop/SQL-query-in-direct-query-mode/td-p/227245

https://community.powerbi.com/t5/Desktop/SQL-parameters-in-direct-query/td-p/248180

[vamshikrishna89]

Thank you for above solutions!!!

I tried the solution you suggested but still report is not getting refreshed. It still shows old refresh time but the cache refresh is made every 15minutes.