Forum Discussion

AndrewDang's avatar
AndrewDang
Helper IV
9 years ago

Set local time zone Power BI Service

Hello all;   I have an issue with setting the right local time for my Power BI Service. I have the same measure to pull the current time. My Power BI desktop file pulls up 1/16/2017 4:36:02 PM whic...
Need Help
Rajiv's avatar
Rajiv
Advocate I
4 years ago

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. 

 

 

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

timcpnz's avatar
timcpnz
Frequent Visitor
3 years ago

Hi Rajiv,
Your solution seems the most elegant but I am not quite following what you are saying. I am currently using a Calendar table which is marked as date table already. Should I be adding a column to that date table and adding a local timezone calculation to it?