Latest update details ?

[suvechha]

Hi All,

How to show the latest dataset refresh details which is showed with green arrow in the power bi app Card visualization ?

[v-xicai · Accepted solution]

Hi @suvechha ,

Within Power BI Desktop, you can add another Power Query dataset to display the current date each time we refresh the report. You may create a new Blank Query, and then add this into the Advanced Editor:

let

    Source = DateTimeZone.FixedUtcNow()

in

    Source

These examples use UTC. You can adjust the query code based on your specific timezone as described in DateTimeZone functions.

For example:

let

Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(),-3)

in

Source

For reference:

 Display Last Refreshed Date in Power BI

Create a column in Power BI for last refresh date

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@suvechha , refer this link for detailed steps

https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

[pranit828]

HI @suvechha 

We need to generate the Last Refresh date ourselves using Power Query.  No big deal, it is as simple as this:

• Open PowerBI Desktop
• Get Data –-> Blank Query
• Go to Home –> Advanced Editor and replace the code in the window with this:

let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
Source

• Click Done and rename the query “LastRefresh_Local”
• Click Close & Apply

To finish it off, we need to create a simple measure and add it to our dashboard.

• Go to your Report window –> New Measure –> Define it as follows:

Last Refreshed (Local) = FORMAT(LASTDATE(LastRefresh_Local[LastRefresh]),"mmm dd, yyyy hh:mm:ss AM/PM")

• Create a Card visual for display

Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!

Regards,
Pranit