Time not pulling from sharepoint list correctly

[akinlaw1]

I have a dashboard that pulls from a sharepoint list with 3 columns of timestampes. The modified column is pulling correct date/time but the " in work" and " Completed" columns have the correct date but wont pull correct time, it will just say 12:00:00 AM. Any ideas whats wrong here? 

[jdbuchanan71 · Accepted solution]

Perhaps somewhere in the applied steps the fields are getting converted to a DATE then later, back to a DATETIME.  If so, you are losing the time portion when it first gets converted to a DATE.  Check all the applied steps in PowerQuery.