Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
U156531
Post Patron
Post Patron

Refresh visuals when report opens in powerbi.com

When I open my PBIX in PowerBI.com my Last Refreshed date field is not displaying the most recent date. I have to click on the Refresh visuals icon in order to get the date to be refrshed. Is there a way to get around this issue. The user should see the latest date so that they know when the report has been last refreshed.

Here is the metthod I'm using to get the Last Refreshed date in the report.

U156531_1-1725544678200.png

 

 

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @U156531 -You can create a measure that dynamically captures the last refresh time.

Last Refreshed = NOW()

rajendraongole1_0-1725545246534.png

 

or 

if you prefer to display the time in UTC

Last Refreshed = UTCNOW()

rajendraongole1_1-1725545305401.png

 

This will work in Power BI Desktop but will refresh only when the dataset itself is refreshed on Power BI Service. The limitation here is that the date won't update unless a data refresh occurs if you want to get the latest date in pbi services with the help of using tools like Power Automate it works.

 

Hope it helps.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @U156531 -You can create a measure that dynamically captures the last refresh time.

Last Refreshed = NOW()

rajendraongole1_0-1725545246534.png

 

or 

if you prefer to display the time in UTC

Last Refreshed = UTCNOW()

rajendraongole1_1-1725545305401.png

 

This will work in Power BI Desktop but will refresh only when the dataset itself is refreshed on Power BI Service. The limitation here is that the date won't update unless a data refresh occurs if you want to get the latest date in pbi services with the help of using tools like Power Automate it works.

 

Hope it helps.

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors