Forum Discussion

rdorsey's avatar
rdorsey
Frequent Visitor
4 years ago
Solved

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 ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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)

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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)