Time Issue, Powerbi Desktop and Sharepoint

[AlexTi]

Hey, 

i have the problem. The Date in my sharepoint list is not the same in the PowerBi Desktop. Maybe in Sharepointlist its 23:00 then it is in PowerBi 00:00. Its depends everytime with the UTC. 

How can i fix that ? 

[ChielFaber · Accepted solution]

You can use the function DateTime.AddZone.

With the help of this function you can make a custom column that changes the UTC datetime value to your local time.

Just add a custom column with DateTime.AddZone([Columname], hours, minutes)

For example:
DateTime.AddZone([Columname], 2, 30)

this adds two hours and 30 minutes to the UTC time

[AnkitKukreja]

Hi @AlexTi 

As PBI handles UTC time it's possible your SP is configured as per your timezone. You might need to fix the time in Power Query or change the time in the Desktop to match your SP time zone. Please see if the previous resolved post helps you.

https://community.powerbi.com/t5/Desktop/Date-value-difference-between-SharePoint-data-source-and-po...