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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JadeM
Frequent Visitor

Adding a time and date stamp when a matrix visual is exported from the app section of PBI Service

I have a series of reports that are located in the 'App' section of the Power BI Service. I would like to configure the visuals in the reports to show a time and date stamp (of the time of the user export) on the excel document which is produced.

 

The visuals are matrices and tables - ideally would like the time and date stamp to be the top row of the exported excel document. But I would consider alternative formats if that is not possible.

 

I cannot see there is a native PBI functionality for this, but does anyone have any ideas of a workaround?

 

Many thanks.

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Hi @JadeM 

You can add a measure and a card to you report

aj1973_0-1702077862846.png

on Export the date and time will be displayed in Excel. Of course adjust the UTC as you wish

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

2 REPLIES 2
aj1973
Community Champion
Community Champion

You can also use Power Query to add a card in your report

aj1973_1-1702078358422.png

let
Source = Table(),
#"Converted to Table" = #table(1, {{Source}}),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date and Time now"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date and Time now", type datetime}})
in
#"Changed Type"

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

aj1973
Community Champion
Community Champion

Hi @JadeM 

You can add a measure and a card to you report

aj1973_0-1702077862846.png

on Export the date and time will be displayed in Excel. Of course adjust the UTC as you wish

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors