PBI Report is throwing this error during a refresh The type of the value does not match the type of

[kg4u]

I am trying to refresh a PBI report and I am getting this error.

    pairs = List.Transform(List.Positions(fieldNames), (i) => {fieldNames{i}, (v) => if v = null or Value.Is(v, fieldTypes{i}) then v else error [Message = "The type of the value does not match the type of the column.", Detail = v], fieldTypes{i}})

in

    Table.TransformColumns(Source, pairs)

I do not know how to fix this, can you please suggest a way to allow me to refresh my report. 

[Anonymous · Accepted solution]

Hi @kg4u ,

This issue appears when your data structure changes and data type conversion failed.(due to data type not matched) Can you confirm these files has same data structure?(e.g. data type, field name, separator... )

You can try In Query Editor, right-click the column and use Replace Values.

I have also found similar posts, please refer to.

Solved: expression.error the type of the value does not ma... - Microsoft Power BI Community

Solved: Data rows error - Microsoft Power BI Community

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.