Date in desktop refreshes but not in PowerBI.com

[U156531]

I'm using the function = DateTime.LocalNow () to create a table in my PBI report to display the date in the report. When I refresh the report in the desktop it updates the date in the report. When I refresh the semantic model in Powerbi.com and open the report the date isn't refreshed. I have to click on the Refresh Visuals button in order to get the date updated in the report. How do I resolve this?

Thanks

[v-junyant-msft · Accepted solution]

Hi @U156531 ,

The report visual object relies on cached data for display, so when your data set is refreshed, the report is still only displayed based on the last cached data. You need to do a manual refresh to display the latest visual objects.
Data refresh in Power BI - Power BI | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bchager6]

@U156531  I believe what you're looking to accomplish can be set up in the Format page section of the Visualizations pane when using Direct Query. Someone asked the same question a while back and Community Supprt answered it here: https://community.fabric.microsoft.com/t5/Service/Auto-refresh-visual-on-report/m-p/518298#M53474