Forum Discussion
Date value difference between SharePoint and Powerbi
Assume that you are using UTC+8 locale datetimes, add a custom column with below code (change 8 according to your locale).
DateTimeZone.SwitchZone(DateTime.AddZone([Date], 0), 8)
Then change this column to DateTime or Date data type per your need.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
This is caused by the timezone difference as Power BI uses the UTC datetimes when it gets data from SharePoint while the SharePoint displays the datetime in your locale. To resolve this, you can use Power Query Editor to create a custom column to convert the UTC datetimes into your locale's datetimes. Then use the new column for further reporting.
Here are some similar threads for your reference:
Date value difference between SharePoint data sour... - Microsoft Fabric Community
timezone - SharePoint Date wrong in Power Bi - SharePoint Stack Exchange
Here is a detailed blog introducing several workarounds for this:
How-To: Convert UTC to Your Local Time Zone in Power Query
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
I tried to create a duplicate column and changed it to local time and it didnt worked
Eg: It should show : 02/01/2024 instead it shows 01/31/2024
Could you please help
Assume that you are using UTC+8 locale datetimes, add a custom column with below code (change 8 according to your locale).
DateTimeZone.SwitchZone(DateTime.AddZone([Date], 0), 8)
Then change this column to DateTime or Date data type per your need.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!