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
M_nwadibia
Resolver III
Resolver III

Appending Timestamp or Date on Standard Subscription

Hello,

I have this scenario on automating my email.

1. I am able to send email using file share and time stamp appended.

2. When I use standard subscription, the time stamp appears on the subject line and not with the attachment.

Is there a way the timestamp can be appended on the attachment using standard subscription?. My datasource is Oracle Data Source

 

M_nwadibia_1-1675095501892.png

 

 

1 ACCEPTED SOLUTION
Medina
Helper II
Helper II

Hi M_nwadibia,

Unfortunately, there is no method to change the report name using the Standard or Data-driven subscription while using the email Distribution option. The email option uses the RDL name as is.

The Windows File Share option allows creating the file, e.g., Excel, with a different name.

View solution in original post

3 REPLIES 3
Medina
Helper II
Helper II

Hi M_nwadibia,

Unfortunately, there is no method to change the report name using the Standard or Data-driven subscription while using the email Distribution option. The email option uses the RDL name as is.

The Windows File Share option allows creating the file, e.g., Excel, with a different name.

jaweher899
Super User
Super User

One option to achieve this is to use a DAX formula to create a calculated column that concatenates the desired date/time value with the existing data. This calculated column can then be used in the report to display the date/time information.

Here's an example of how to do this:

  1. Create a calculated column: In Power BI Desktop, go to the "Modeling" tab and select "New Column." Enter a name for the calculated column, such as "Date/Time," and enter the following DAX formula:

=TEXT(NOW(), "MM/DD/YYYY HH:MM:SS")

  1. Use the calculated column in the report: Go to the "Visualizations" pane and add the calculated column to the report. This will display the date/time information in the report.

This approach will allow the user to append a timestamp or date to their Power BI report when using a standard subscription.

This is SSRS and not Power BI

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors