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 tha...
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.