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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aaande8
Frequent Visitor

Last Refresh Date

I want to disable auto refresh when opening the file. Then when the data is refreshed using the refresh all icon I'd like to have a date within a cell of excel to update to the date its last refreshed. Below are the screen shots of my current formula and second screen shot is the data model where I inserted a lastrefresh date column which looks to the Request Completion date. Am not sure if its necessary to even insert a lastrefreshed column. But am getting an error within the formula. Capture.PNGCapture2.PNG

 

1 REPLY 1
TeigeGao
Solution Sage
Solution Sage

Hi @aaande8 ,

This is a problem with PowerPivot, I would suggest you opening a thread in PowerPivot forum at https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlkjpowerpivotforexcel&filter=alltypes&so...

Best Regards,

Teige

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.