Forum Discussion
Power BI Service Direct query refresh issue
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!!!
2 Replies
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
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.
