Forum Discussion
Time not pulling from sharepoint list correctly
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?
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.
1 Reply
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.