Problem about the timezone of Power BI Desktop and Service

[phchu1226]

Hi all,

I am still really confused about the timezone after reading many articles. There are few questions.

1) This is captured from my desktop. I don't know why the relative date filter of powerbi desktop do not synchronize with my desktop timezone? 

What I expected is that "Relative date - in this day" should be 1/11/2022 on the filter?

Also, from this link: https://community.powerbi.com/t5/Service/Set-local-time-zone-Power-BI-Service/m-p/114120,

it said "a filter for relative date of today, gives us today in UTC time, not the other 23 time zones",  is this limitation only for powerbi service? or both of powerbi desktop and service? Any fix/update so far?

2) I had created a date table for clarify the date range of "Today","MTD","YTD", etc. 

abstract:

date_type =

VAR TodayDate = TODAY()

VAR Result =

ADDCOLUMNS(

CALENDAR(TODAY(),TodayDate),

"Selection","Today",

"Ordering",1

)

When I looked at the table at powerbi desktop, the result is correct, 11/01/2022 = Today, the visual is normal.

However, I looked at powerbi service, the table is wrong, it showed 10/01/2022 = Today, so that all the data display on the visual is false. It shows the data on the previous day. How can I fix this? 

The most weird thing is that I published this report to "My workspace", the date table and the visual is normal, it showed the correct data while another workspace I created before not, it showed the wrong data. What is the reason behind?

3) data source 

I am using SQL to extract the data, I think the "sysdate" inside the SQL statement should not be affected by the powerbi timezone as the "sysdate" is looking at the date of database server, right?

[amitchandak]

@phchu1226 , Power bi service can take timezone from browser , so need to correct that

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

https://www.youtube.com/watch?v=2kmFfbOeFJg

or refer

https://4pbi.com/resolving-timezone-issue-on-power-bi-service/

[phchu1226]

@amitchandak ,

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

I am not able to find that tab to config the timezone setting.. it is feature still available now?

[v-rzhou-msft · Accepted solution]

Hi @phchu1226 ,

I think you can try to add a date column with the timezone you need in Power Query then publish it to Power BI Service.

For reference: changing timezone of powerbi service?

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.