cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
TrulsBj Occasional Visitor
Occasional Visitor

Wrong date/time for Sharepoint list date fields in Power BI

Hi, 

I have Connected to Shaepoint Online list, and the date Fields are wrong in Power BI. For SP Fields With date/time - it is 2 hour wrong, for dates only Field, the date  is 1 day wrong.  Im located in Norway. 

 

examlpe: 

[Stop date] Field in Sharepoint: 1.10.2019

[Stop date] Field in Power BI: 30.9.2019

 

[Created] Field in Sharepoint: 1.10.2019 11:10

[Created] Field in Power BI: 1.10.2019 09:10

 (2 hour difference)

After October 27th, the time difference in clock is 1 hour.  This seems to be a Daylight savings  problem. 

 

Is it a easy way to change this to be correct, and is it possible to send a report file With the correct formulas ?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Wrong date/time for Sharepoint list date fields in Power BI

@TrulsBj 

 

Here is a similar case for your reference.

https://community.powerbi.com/t5/Desktop/Created-time-for-records-is-changing-when-connected-to-onli...

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Wrong date/time for Sharepoint list date fields in Power BI

@TrulsBj 

 

Here is a similar case for your reference.

https://community.powerbi.com/t5/Desktop/Created-time-for-records-is-changing-when-connected-to-onli...

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,317)