Unanswered

Adding or Format Date/Time of when the Power BI dataset was last refresh in a email

(0) Share

Report

Posted on by KONeill102399

I built a flow to query a power bi dataset to create a HTML and CSV file to be emailed once a month to monitor a error. In the email I would like to add the date/Time the dataset was refreshed. I am new to power automate so I did not know how to display it as a field so I created a table then added the field from the table to the email. However, the format is not how I wanted it listed (see last picture of email). Can someone provide help on either the format, steps that need to be fixed, or link to a video?

Run Query in Power BI Dataset

2.Select the query results

Select Query Date_Time Refresh.png

3. Format query results as table (only because I didn't know how to add it to the email as a feild)

Create Table.png

4. Add the field from the query results table

Results is not in the format I want.

2024-05-08 14_19_00-YOTC Change Monitoring Report 05_08_2024 - Message (HTML).png

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report

Hi, @KONeill102399

If you want to get the DateTime from your "Select Date Refresh Query" action, you can try to use this code:
outputs('Select_Date_Time_Refresh_Query')?[0]?['[Last Refresh]']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
KONeill102399 68 on at

Like (0)

Report

Thank you. That worked perfect.

Was this reply helpful? Yes No