Power Query Problems

Fix Power Query Time Values Loading Incorrectly from SharePoint

Muhammad TalhaMuhammad Talha Nov 14, 2026 868 views

Question details

Troubleshoot time values that import incorrectly from an Excel file stored on SharePoint.

Fix Power Query Time Values Loading Incorrectly from 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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect an affected cell

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.

2
Extract the time if needed

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.

3
Update and retest the import

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.

If there is no date component: If the source values are already time-only, test a small text-based sample and inspect the query's conversion steps.
Free Microsoft Office alternative

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.

Inspect and prepare time columns before importing them into Power BICompatible with Microsoft Excel XLS and XLSX filesFamiliar spreadsheet interface for an easier transition from ExcelFree, lightweight tools for everyday office work
microsoft office alternative - wps office

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.