Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
Hello,
Did you find a solution to this. ?
I am not able to add it to the hierarchy. Could you please help me out
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.