Solved: Time Issue, Powerbi Desktop and Sharepoint

AlexTi · ‎03-28-2023

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 · ‎03-28-2023

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

[Tip] Keep CALM and DAX on.
[Solved?] Hit “Accept as Solution” and leave a Kudos.
[About] Chiel | SuperUser (2023–2) |

View solution in original post

ChielFaber · ‎03-28-2023

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

[Tip] Keep CALM and DAX on.
[Solved?] Hit “Accept as Solution” and leave a Kudos.
[About] Chiel | SuperUser (2023–2) |

AnkitKukreja · ‎03-28-2023

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

For Power BI trainings or support dm or reach out to me on LinkedIn.
If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904