DARTS : Adding Data Refresh Date and Time

Power BI uses Universal time which cause discrepancies on the reports Power BI Service. Here is one of the remedy for date and time.

Go to Power Query Editor (Transform Data)

Go to New Source > Blank Query. Copy this DAX to Advanced Editor.

let
    Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}}),
    #"LocalDateTime" = Table.AddColumn(Source, "LastRefeshLocal", each DateTime.AddZone([LastRefresh], 5)),
    #"Changed Type" = Table.TransformColumnTypes(LocalDateTime,{{"LastRefeshLocal", type datetime}, {"LastRefresh", type datetime}})
in
    #"Changed Type"

It will create a new table.
Name the table and "Close & Apply".
Use "LastRefreshLocal" on your report if report is published to Power BI Service.
For daylight saving time, change this line (from "5" to "4")
#"LocalDateTime" = Table.AddColumn(Source, "LastRefeshLocal", each DateTime.AddZone([LastRefresh], 4)),

HELP IS AT HAND!

Link to compose email for help with website.

Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.

DARTS : Adding Data Refresh Date and Time

Power BI uses Universal time which cause discrepancies on the reports Power BI Service. Here is one of the remedy for date and time.

Attachments: