Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |