Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
AlexTi
New Member

Time Issue, Powerbi Desktop and Sharepoint

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 ? 

ZEIT1.PNG

1 ACCEPTED SOLUTION
ChielFaber
Super User
Super User

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

 

 

View solution in original post

2 REPLIES 2
ChielFaber
Super User
Super User

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
Super User
Super User

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
https://topmate.io/ankit_kukreja

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.