cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ryank Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Moderator v-caliao-msft
Moderator

Re: changing timezone of powerbi service?

@ryank,

 

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

3 REPLIES 3
deldersveld
Advisor

Re: changing timezone of powerbi service?

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

Moderator v-caliao-msft
Moderator

Re: changing timezone of powerbi service?

@ryank,

 

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

Yoga Regular Visitor
Regular Visitor

Re: changing timezone of powerbi service?

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