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.

     

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..  😊