Forum Discussion
Helper IIPBI Report is throwing this error during a refresh The type of the value does not match the type of
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.
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.
1 Reply
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.