Power BI in PPT - Data updated feature

[majudd]

When I embed a Power BI page into PPT, the bottom left hand corner lists "Data updated". This gives the date and the time. For pages set to "Live data" it updates the date every day I open the PPT, but for those set to "Screenshot", it retains the date PPT was created. However, the time is always set to 1:16 AM, no matter when I create or open the PPT. Is there a way to get the correct time?

[v-kathullac · Accepted solution]

Hi @majudd,

Thank you for reaching out to Microsoft Fabric Community Forum.

The 1:16 AM timestamp comes from Power BI’s internal rendering process. It appears consistently due to how the report image is generated behind the scenes and is not dynamically tied to your Power BI dataset or refresh schedule.

You can try the following steps to display the actual refresh time:

1. Add Actual Refresh Time in the Report:
   Create a measure or card visual in Power BI to show the latest data refresh using:
   "Last Refreshed: " & FORMAT(NOW(), "dd-mmm-yyyy hh:mm:ss AM/PM")
   or
   "Last Refreshed: " & FORMAT(LASTDATE('YourTable'[DateColumn]), "dd-mmm-yyyy hh:mm:ss AM/PM")

2. Place this card visibly in your report.

3. When you embed the report into PowerPoint (either in Live or Screenshot mode), this card will display the actual refresh timestamp from your data model.

For more information, refer to the official Microsoft documentation:
🔗 Add live Power BI data to PowerPoint

Regards,

Chaithanya.

[majudd]

Thank you. Were do I click 'yes' to mark the response as helpful? - Elizabeth

[vks20]

What if I am using a direct query to a semantic model? I get the date of last refresh of the my individual dataset in the Powerpoint presentation. How can I make it dynamic and similar to my main data model.

@v-kathullac 

[v-kathullac · Accepted solution]

Hi @majudd,

Like is nothing but hitting the ok button beside the reply attaching the screenshot for reference

Regards,

Chaithanya.

[v-kathullac]

Hi @majudd ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya

[v-kathullac · Accepted solution]

Hi @majudd,

Thank you for reaching out to Microsoft Fabric Community Forum.

The 1:16 AM timestamp comes from Power BI’s internal rendering process. It appears consistently due to how the report image is generated behind the scenes and is not dynamically tied to your Power BI dataset or refresh schedule.

You can try the following steps to display the actual refresh time:

1. Add Actual Refresh Time in the Report:
   Create a measure or card visual in Power BI to show the latest data refresh using:
   "Last Refreshed: " & FORMAT(NOW(), "dd-mmm-yyyy hh:mm:ss AM/PM")
   or
   "Last Refreshed: " & FORMAT(LASTDATE('YourTable'[DateColumn]), "dd-mmm-yyyy hh:mm:ss AM/PM")

2. Place this card visibly in your report.

3. When you embed the report into PowerPoint (either in Live or Screenshot mode), this card will display the actual refresh timestamp from your data model.

For more information, refer to the official Microsoft documentation:
🔗 Add live Power BI data to PowerPoint

Regards,

Chaithanya.