High severitydata source
Power BI Refresh Error:
ParquetDataCountNotMatchColumnCount
What does this error mean?
The number of values in a Parquet row does not match the number of columns in the file schema — the file is structurally inconsistent.
Common causes
- 1The Parquet file was corrupted during write — a partial row was written before the process was interrupted
- 2The Parquet writer has a bug that sometimes generates row groups with mismatched column counts
- 3The file was modified after writing, breaking the internal column count consistency
How to fix it
- 1Validate the Parquet file using Parquet Tools or DuckDB to identify the corrupted row group.
- 2Re-generate the Parquet file from the source system.
- 3If only some row groups are corrupted, consider using a Spark notebook to read only the valid row groups and write a clean Parquet file.
Frequently asked questions
Official documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-parquet