Sharepoint timezone and Power Bi Timezone not matching

[nagoor]

Hi Experts, 

I have datasource from Sharepoint online list where the timezone is in UTC +10, after i imported the data i shows the date field in the table is showing as UTC +0, i have to report the data in UTC +10 timezone only, is there any easy way to convert the timezone or fix the timezone in Power bi, 

[v-eachen-msft]

Hi @nagoor ,

You could edit the timezone manually.

1. DAX:

Column = 
'Table'[Your timezone data]+ 10/24

2. Power query

DateTimeZone.SwitchZone([Your timezone data],10,0)

[nagoor]

Hi @v-eachen-msft 

Thanks it worked in Power Query, but its working fine when its in Desktop if i piblished the same, i'm still getting the UTC +0 time only 😞 anything would help me on this 

Desktop - Time zone changed

Web - Time Zone Not changed

[v-eachen-msft · Accepted solution]

Hi @nagoor ,

You could try the following codes in query editor:

[DateTime] + #duration(0,10,0,0)

 There two methods worked on my side.

[nagoor]

Hi @v-eachen-msft : I tried the second option, it worked... 

Thanks a lot for your support..  😊

[amitchandak]

@nagoor , refer , if these can help

https://community.powerbi.com/t5/Power-Query/Adjusting-SharePoint-Created-Modiifed-Timestamp-columns...

https://radacad.com/solving-dax-time-zone-issue-in-power-bi