Can I have dynamic subject when sending an Email using Power BI subscribe to report ?

[Anonymous]

I published a dashboard on a power BI server.

What I am trying to do is to add a subscription to this published report and send it in pdf format by Email.

An issue that I am facing is that I want the subject of the email to be dynamic, for example: Report Name - Yesterday's date

I tried several ways to achieve that:

Way 1: "Report Name - " & FORMAT(TODAY()-1, "yyyy-MM-dd") OR Report Name - [Today() - 1]. Tried both formulas: directly added in the subject

Way 2: Creating a column in power BI called ReportDate using the FORMAT(Today()-1, "yyyy-MM-dd")] and then adding the name of the column in the subject between brackets

None of those ways are working. So I would like to ask if is this even possible to do?

[Anonymous]

Hi!
Actually this is very interesting, as I'm trying to do it now. I believe @lbendlin did not fully understand. I want to add the subscription, and set the email subject to be "Errors from day yyyy-MM-dd" and be able to select the date before, and set it in the subject in the stated format.

I've tried the same ways before reaching this topic, but would be great to know if there's a chance to add a dynamic subject (or even body, if not possible on the subject) to make it automatic.

Thanks in advance!

[lbendlin]

my answer still stands - use Power Automate for that. It gives you full flexibility on the email format.

[lbendlin]

Use Power Automate to run DAX queries and then add the results to emails that you can fully customize.