Forum Discussion

nagoor's avatar
nagoor
Icon for Helper III rankHelper III
6 years ago
Solved

Sharepoint timezone and Power Bi Timezone not matching

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 t...
Need Help
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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's avatar
nagoor
Icon for Helper III rankHelper III
6 years ago

Hi 

 

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's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
    nagoor
    Icon for Helper III rankHelper III
    6 years ago

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

     

    Thanks a lot for your support..  😊