Is it possible to include current timestamp in the excel exports from Power BI

[ArmEncarn]

Hi gurus,

When using Export Data in a table visual in Power BI, is it possible in include the current timestamp in the excel output showing the current date and time when the user exported the report to Excel? I tried to add the current datetime using Now() function in my dataset but it only shows the time when the data is refreshed in Power BI and not the actual time when you view the report in Power BI service. Appreciate any help from you guys. Thank you. 

[vedika1089]

Hello,

Did you find a solution to this. ?

[vedika1089]

I am not able to add it to the  hierarchy. Could you please help me out

[lbendlin · Accepted solution]

Create a measure

measure = NOW()

and add it to your visual (hide it in the hierarchy, or make its column width zero).

Depends on where you live thought. Might want to go with UTCNOW()

NOTE:  This is just the "Last exported" date.  It has no relation to the currency of the actual data and may lead to unintended consequences/interpretations.  The optimal approach is to use a "Last Modified" date from your actual data instead. That's the only meaningful date.