Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.