Display the Refresh Date Time at Different Time Zone in Power BI

If you have completed the report and published the Power BI Report and set it as a scheduled refresh and we are not able to see the Date and time in the Power BI report. For this problem, we can find the Solution in Two way in this Blog

The Two Steps are Follow

1. Display UTC Date Time

2. Convert the UTC Date Time to Different Time Zone

Steps to Display the UTC Date Time

1. First thing you need to open the Power BI Query editor

2. Select the New Source → Blank Query

3. Edit the Query using, Advance Editor Advanced Editor and replace the code in the window with this

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

4.After Done you can find the table with the Last Refresh Time

Our Next Step to Convert the UTC Date Time to Different Time Zone

For our example: we are Going to convert the UTC time to USA Locale (Chicago UTC -6)

1. For the Above Scenario take a blank query and Advance editor Advanced Editor and replace the code in the window with this

let

Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}}),

#”Added Custom” = Table.AddColumn(Source, “Custom”, each [Date Last Refreshed] + #duration(0,-6,0,0)),

#”Renamed Columns” = Table.RenameColumns(#”Added Custom”,{{“Custom”, “USA Local Time 6:00”}})

in

#”Renamed Columns”

2. From the Above Code you can find the + #duration(0,-6,0,0)), which represent the Duration(Day, Hours, Minutes, Seconds)

3. Apply and close the power Query editor

4.Drag and drop the Date and time

Follow us for more such topics and suggestions.,
Also click the link below to follow us in LinkedIn https://www.linkedin.com/showcase/sphyzee-analytics/about/