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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

changing timezone of powerbi service?

Is there any way I can change the timezone of the PowerBI Service?

 

I read that it is effectively set at UTC which would explain why when I use TODAY() and YESTERDAY() DAX in my PBIX reports, they are fine locally, but clearly out of sync when they are published to the web service. 

 

 

1 ACCEPTED SOLUTION
v-caliao-msft
Microsoft Employee
Microsoft Employee

@Anonymous,

 

We can switch time zone when add a custom column. I have tested it on my local environment.

Untitled.pngUntitled1.png

Capture.PNG

 

Regards,

Charlie Liao

View solution in original post

6 REPLIES 6
Rajiv
Advocate I
Advocate I

I was having this issue where the times that showed in local time zone on my PowerBI Desktop, turned into UTC when published on cloud service. I was able to solve this by first adding a local timezone as table (see Showing Specific Timezones in Power BI Service (Last Refreshed Time) - YouTube). And then mark the resultant table as a Date Table as shown below. Once it is marked as a date table, it almost resets the time zone on your power bi service to local. 

Rajiv_0-1642559899488.png

 

Rajiv_1-1642559899325.png

 

 

 

P.S. This also worked on PBI Report Server where I was having the same issue.

Keano
Frequent Visitor

Using a custom column does not work if the time zone has 'Daylight saving' as the date on which the hour goes back or forward changes twice a year

In this case you must use API service to get the correct time, kinda crazy you need to get an api to external service to solve this, Microsoft should provide this as part of it's cloud service to supports demands and calls from the service

 

See this document fr the difernet options , method 3 is your best bet if you are in a zone with daylight saving  https://radacad.com/solving-dax-time-zone-issue-in-power-bi 

v-caliao-msft
Microsoft Employee
Microsoft Employee

@Anonymous,

 

We can switch time zone when add a custom column. I have tested it on my local environment.

Untitled.pngUntitled1.png

Capture.PNG

 

Regards,

Charlie Liao

Anonymous
Not applicable

There no such thing as minus 3 timezone. Time zone have a name to take account of the summer / winter time difference with UTC.

I am unable to add columns in Direct Query mode. Can you please let me know the solution for Direct Query mode?

deldersveld
Resident Rockstar
Resident Rockstar

There is currently no way to change time zone in Service. This other thread has some links with additional suggestions: https://community.powerbi.com/t5/Service/Set-local-time-zone-Power-BI-Service/td-p/114120

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.