Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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.
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.
@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