Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |