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:
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)
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)
Helpful resources
Announcements
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
