SQL Data Mapping
14 articles
Troubleshooting “XML parsing error” when importing SQL XML data types.
When importing records containing SQL Server XML columns into Excel, data refreshes frequently halt with the…
Fixing “Precision Loss” when importing SQL DECIMAL(38,18) into Excel.
When importing high-precision monetary, scientific, or cryptographic data from SQL Server into Excel, numbers often lose…
Handling “GUID” (Uniqueidentifier) conversion errors in Power Query.
In SQL Server, a Globally Unique Identifier (GUID) is stored as a 16-byte binary value under…
Troubleshooting “Scientific Notation” conversion of SQL ID strings.
When importing numeric identifiers from SQL Server into Excel, numbers like account references, order IDs, tracking…
Fixing “Invalid Cell Value” when SQL returns non-printable ASCII characters.
When importing records from SQL Server into Excel, users often encounter refresh crashes, blank cell replacements,…
Fixing “DataFormat.Error: We couldn’t parse the input as a Boolean.”
When loading data from SQL Server or transactional APIs into Excel through Power Query, queries often…
Handling “Null” values that break Power Pivot “Relationship” integrity.
When building analytical data models in Excel using Power Pivot, creating relationships between tables frequently triggers…
Troubleshooting “Locale” errors: Importing SQL YYYY-MM-DD into MDY Excel.
When importing SQL Server dates into an Excel workbook configured for US Month-Day-Year (MDY) regional settings,…
Fixing “Truncated Data” errors when importing SQL VARCHAR(MAX) columns.
Importing text-heavy SQL Server records into Excel often triggers unexpected data cuts or stops with driver…
Solving Date/Time offset errors: “The value is not a valid DateTimeZone.”
When pulling time-stamped transactional records from relational databases into Excel, imports frequently stop on the error:…
Handling “Arithmetic Overflow” when importing BigInt data into Excel.
When importing SQL Server tables into Excel, encountering an arithmetic overflow or seeing large numeric identifiers…
Troubleshooting “Primary Key” violation errors during the Load-to-Data-Model phase
A “Primary Key” violation occurs in Excel when you load data into the Power Pivot Data…