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

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/

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Climbing up the Binary Trees in C++

189. Rotate Array

Introduction to mockito-scala — Part 2

Experience creating a high level architecture and how it helps to see an overall picture of the…

Understanding the Principles behind Agile Manifesto — Part 1

I made my first open source contribution within 200 days (and how you can too)

What I learned Dec 14th — Dec 20th

Behaviour Driven Development (BDD)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sphyzee Analytics

Sphyzee Analytics

More from Medium

We have the Sale date and in that, we want to show the month-wise revenue in that the client wants…

Biodiversity Observation Monitor Data Das

Tableau | How to show tooltip visualization only on click and not on hover

Tableau 101 — Hierarchy and Dashboard