Formatting Types
13 articles
Troubleshooting XML Namespace errors in Power Query.
XML Namespace errors occur in Power Query when importing XML feeds, SOAP services, or complex schemas…
Fixing “DataFormat.Error: The JSON input is invalid.”
The error DataFormat.Error: The JSON input is invalid occurs in Power Query when the Json.Document function…
“The value was too large or too small for an Int64”: Fixing Integer Overflows
The error "The value was too large or too small for an Int64" occurs in Power…
DataFormat.Error: The input is not a valid Base64 string.
The error DataFormat.Error: The input is not a valid Base64 string occurs in Power Query when…
Handling “Extra Columns” that appear unexpectedly in Folder Imports.
Unexpected extra columns (such as Column11, Column12, or duplicated column names) appear during Power Query folder…
Fixing “Scientific Notation” errors (e.g., 1.23E+10) during data import.
Scientific notation errors (such as 1.23457E+10) occur during data import when Excel or Power Query interprets…
Troubleshooting “Truncated Data” errors in long text columns (>32k characters).
Truncated data errors occur in Excel when importing text strings that exceed the 32,767-character limit of…
How to handle “null” values that break mathematical transformations.
In Power Query, null represents the complete absence of a value. When performing mathematical transformations, such…
Fixing “DataFormat.Error: Invalid cell value” in Excel imports.
A DataFormat.Error: Invalid cell value occurs in Power Query when the Excel data connector encounters a…
Handling “Locale” errors: Importing DMY dates into an MDY system.
This problem occurs when dates formatted in a Day/Month/Year (DMY) pattern, standard across the UK, Europe,…
DataFormat.Error: The value is not a valid Number (Dealing with Currency symbols)
Encountering DataFormat.Error: The value is not a valid Number inside Power Query halts your data pipeline…
DataFormat.Error: We couldn’t parse the input provided as a Date.
Encountering DataFormat.Error: We couldn't parse the input provided as a Date means your Power Query data…