Medium severitydata source
Power BI Refresh Error:
ParquetInvalidDecimalPrecisionScale
What does this error mean?
A DECIMAL column in the Parquet file has precision or scale outside ADF's valid range. ADF supports precision up to 38; scale must be less than or equal to precision.
Common causes
- 1The Parquet writer used a precision or scale value outside the supported range (precision > 38 or scale > precision)
- 2The decimal column precision was set to an invalid value such as 0 or a negative number
How to fix it
- 1Check the DECIMAL column definition in the Parquet file schema using a Parquet viewer.
- 2If the precision exceeds 38, cast the column to a string type and handle it as a high-precision numeric string.
- 3Update the Parquet writer to use a valid precision (1–38) and scale (0 to precision).
Frequently asked questions
Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-parquet