Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Problem with timezones

Hi, I have a KPI in my report that shows the latest refresh. The problem is that it changes when I publish it to the server, maybe is a problem with the timezone. This are the steps that I've done:

 

1. Power Query Script:

1.png

 

2. Power Query Result:

2.png

 

3. DAX

3.png

 

4. KPI result (Time is OK):

4.png

 

5. Server: The tooltip with Data updated is showing the right time, but the KPI in the report has +3 hours.

 

5.png

Also, the timezone of the Dataset is OK:

milomilo_0-1606494407176.png

 

 

What can I do to fix this?

 

Thanks

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Solution in Power Query;
Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(), -4), #"Converted to Table" = #table(1, {{Source}}), #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "LastRefreshDate"}}), #"Added Custom" = Table.AddColumn(#"Renamed Columns", "AsOf", each "As of "&DateTimeZone.ToText([LastRefreshDate], "MM/dd/yyyy hh:mmtt")),

Show less

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Solution in Power Query;
Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(), -4), #"Converted to Table" = #table(1, {{Source}}), #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "LastRefreshDate"}}), #"Added Custom" = Table.AddColumn(#"Renamed Columns", "AsOf", each "As of "&DateTimeZone.ToText([LastRefreshDate], "MM/dd/yyyy hh:mmtt")),

Show less

amitchandak
Super User
Super User

@Anonymous , check if this setting in power bi service can help

https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Thanks but I can't find that section. Where is it supposed to be in the Power BI Service?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!