Forum Discussion

BHinote's avatar
BHinote
Frequent Visitor
6 years ago

Convert Timezone based on User Selection (PowerBI.com)

I have been using Power BI for a couple of months now and have run into the same issue as many other people, regarding the issue of showing Date Time fields relative to the end user's Time Zone.  I h...
Need Help
PBILover's avatar
PBILover
Helper V
6 years ago

Hi did you got any solution on this? can you please let me know , i am facing similar situation at my end.

BHinote's avatar
BHinote
Frequent Visitor
6 years ago

Unfortunately No.  I was forced to create separate reports for the various timezones needed, as there does not appear to be a solution for this.

 

I do not know why the Power BI Team has not addressed this issue, as everything I have found converts the UTC Time and Zone based on the Servers Timezone and not the User's Timezone.  Considering that most National and/or International Businesses will have users and/or clients that work from timezones other than where the data is served it does not make sense that there would not be a solution to address this issue.  Maybe I am wrong, but at a minimum couldn't they just provide an option in the User's Profile that allows the user to set the Timezone they work from and then allow the Date/Times to be converted base on that...   I do not know, but this is a major problem..