cancel
Showing results for 
Search instead for 
Did you mean: 
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
Resolver IV
Resolver IV

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
Resolver IV
Resolver IV

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

 

 

If my response has addressed your question or concern, kindly mark this post as resolved. If you found my assistance helpful, consider giving it a thumbs.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors