How to get last refresh date in power bi dashboard

[Sugumaran31]

Hi Guys,

My Requirement for How to get a last refresh date and time from the Power BI Service to the dashboard. Please anyone known to reply to me is a urgent client requirement

Thanks and Regards

Sugumaran C

[uzuntasgokberk · Accepted solution]

Hello @Sugumaran31,

In Power Query you can write an m code. For ınstance open a blank report and write 

DateTime.LocalNow()

  Close and appy. You can use as a card and publish in to PBI Service. But be sure date time value is correct in PBI Service. İf it isn't you might be doing some plus or minus with your creating dax code.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[Kaviraj11 · Accepted solution]

Hi,

Create a table in power query, adjust your timezome accordingly.

= DateTime.LocalNow()+#duration(0,-4,0,0)

[uzuntasgokberk · Accepted solution]

Hello @Sugumaran31,

In Power Query you can write an m code. For ınstance open a blank report and write 

DateTime.LocalNow()

  Close and appy. You can use as a card and publish in to PBI Service. But be sure date time value is correct in PBI Service. İf it isn't you might be doing some plus or minus with your creating dax code.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |