Visual with latest refresh date

[answeriver]

Hello. I have report in power bi with sharing with colleagues. My data doesn't have date, but report refreshing automatically. Maybe power bi have some function which shows last refresh date of report automatically?

[RohithGn · Accepted solution]

I have used a workaround to achieve this. , so i created the below table using Blank Query - 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "IST", each  (DateTimeZone.LocalNow()+ #duration(0,5,30,0))),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "PST", each  (DateTimeZone.LocalNow()+ #duration(0,-7,00,0))),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "GMT", each  (DateTimeZone.LocalNow())),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom2",{{"IST", type datetimezone}, {"PST", type datetimezone}, {"GMT", type datetimezone}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Column1"})
in
    #"Removed Columns"

Tweak the custom columns as per your wish as our Power BI Tenant Service is in GMT, so i added 5:30 hrs to get IST and reduced 7 hours for PST. Then, I added the timestamp in the Card Visual as below - 

Whenever the report is refreshed the timestaps is auto-updated

Hope this helps.

[answeriver]

Thanks all,

Actualy after last update of Power Bi information of last update is showing.

[Tahreem24 · Accepted solution]

Hi @answeriver ,

You can get your answer from the below mentioned URL:

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

Please mark this as a Solution so it may help others!

[RohithGn · Accepted solution]

I have used a workaround to achieve this. , so i created the below table using Blank Query - 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "IST", each  (DateTimeZone.LocalNow()+ #duration(0,5,30,0))),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "PST", each  (DateTimeZone.LocalNow()+ #duration(0,-7,00,0))),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "GMT", each  (DateTimeZone.LocalNow())),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom2",{{"IST", type datetimezone}, {"PST", type datetimezone}, {"GMT", type datetimezone}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"Column1"})
in
    #"Removed Columns"

Tweak the custom columns as per your wish as our Power BI Tenant Service is in GMT, so i added 5:30 hrs to get IST and reduced 7 hours for PST. Then, I added the timestamp in the Card Visual as below - 

Whenever the report is refreshed the timestaps is auto-updated

Hope this helps.