Fix Power Query Time Values Loading Incorrectly from SharePoint
Question details
Troubleshoot time values that import incorrectly from an Excel file stored on SharePoint.

- Product
- Power Query in Power BI and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user imports an Excel table containing a Time column from SharePoint into Power BI.
- Observed behavior
- Power Query returns errors or 00:00:00 for time values even though the source column is formatted and typed as Time.
Open the source workbook in Excel and identify a few affected cells and their expected times. In Power Query Editor, select the query and check Applied Steps to see where the values change or errors appear.
Check for hidden dates in the source time values
Use this check when cells display only a time but may contain a date as part of the underlying value.
Excel formatting can hide a date component. A time-only Excel value normally has an integer part of zero.
In Excel, select a blank cell and enter =INT(A2), replacing A2 with an affected time cell. A nonzero result indicates an integer component, such as a date.
For a numeric date-and-time value, enter =MOD(A2,1) in a helper column and format the result using Home > Number Format > Time. Repeat for the affected rows.
Copy the corrected helper values and use Paste Special > Values to replace the source values. Save the workbook to SharePoint, then refresh the query in Power BI.
Test a text-only sample in a new SharePoint workbook
Use a small sample to determine whether the issue is tied to the source workbook or the import steps.
Inspect Excel Time Values with WPS Spreadsheets
WPS Office is a free, lightweight alternative for opening and preparing spreadsheet files in a familiar interface. It can help you inspect time values before moving an Excel workbook into Power BI, though it does not fix Power Query itself.

Frequently Asked Questions
Why can a cell formatted as Time still contain a date?
The Time number format controls what Excel displays, not the entire stored value. Enter =INT(A2) in a blank cell to check the integer component of a numeric value.
Where can I see which Power Query step changes my time values?
In Power BI Desktop, select Home > Transform data, choose the query, and click through Applied Steps. Compare the values before and after steps such as Changed Type.
How can I test whether text time values convert correctly?
In Power Query Editor, select the column and choose Transform > Data Type > Using Locale. Select Time and the locale appropriate for the text values, then check the preview for errors.
What should I share if the time values still load incorrectly?
Provide a downloadable sample Excel workbook with a few affected rows, the expected times, the SharePoint connection method, and the Power Query step where the values change.




