Power BI Service Direct query refresh issue

vamshikrishna89 · ‎09-23-2019

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 · ‎09-23-2019

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

vamshikrishna89 · ‎09-24-2019

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.