Forum Discussion
Power Query Importing 24hr dates incorrectly
I have a sharepoint list with "Start" and "End" fields. These are standard date and time fields displayed in 24hr time format. When I import these columns to Power BI with the SharePoint Online List connector it changes the time to 12hr time, but it's the wrong value. I can't figure out what it's doing or what I'm doing wrong, but this is obviously a serious issue for my reporting. A few examples are below:
| Sharepoint | Power Query |
| 15:00 | 8:00PM |
| 12:00 | 5:00PM |
| 21:48 | 2:48AM |
| 10:30 | 3:30PM |
| 14:14 | 7:14PM |
This is due to time zone. Your all times are off by +5 hours. After import, you can put following formula to convert back to right time (Replace Time Column appropriately)
= [Time Column]-#duration(0,5,0,0)
1 Reply
This is due to time zone. Your all times are off by +5 hours. After import, you can put following formula to convert back to right time (Replace Time Column appropriately)
= [Time Column]-#duration(0,5,0,0)