Hello! Help with error

[Syndicate_Admin]

Hello community! I thank you in advance for your recommendations and sincere support to solve the following error, when I have updated the Data table it tells me that there is a match error and to repair it, it generates a new index column, I have reviewed the table and I do not find the rows with errors, then delete the changed type step and I did it again taking care that it is not an error by type, But the error persists, so far I have not found a way to solve it. Here is what appears to me:

= let
tableWithOnlyPrimitiveTypes = Table.SelectColumns(Origen, Table.ColumnsOfType(Origen, {type nullable number, type nullable text, type nullable logical, type nullable date, type nullable datetime, type nullable datetimezone, type nullable time, type nullable duration})),
recordTypeFields = Type.RecordFields(Type.TableRow(Value.Type(tableWithOnlyPrimitiveTypes))),
fieldNames = Record.FieldNames(recordTypeFields),
fieldTypes = List.Transform(Record.ToList(recordTypeFields), each [Type]),
pairs = List.Transform(List.Positions(fieldNames), (i) => {fieldNames{i}, (v) => if v = null or Value.Is(v, fieldTypes{i}) then v else error [Message = "El tipo del valor no coincide con el tipo de la columna.", Detail = v], fieldTypes{i}})
in
Table.TransformColumns(Origen, pairs)

The steps in the query:

Thank you for your comments.

[v-jingzhang]

Hi @Eli_r06 

Can you show a screenshot of the error? From the current screenshot, the "changed type" step seems work and there is no error displaying. When and where does the error appear? Did you do any operation before it appeared?

Best Regards,
Community Support Team _ Jing

[Syndicate_Admin]

I saw the text I placed [Message = "The type of the value does not match the type of the column.", Detail = v], fieldTypes{i}}), you can find the error in 124 rows with data #N/A because they were fields with formula that showed error, what I did was check the error in the formula, correct the values and when updating the power bi I no longer got an error.

Thank you for your reply 🙂

[v-jingzhang]

Hi @Eli_r06 

Glad you have solved it by yourself and share the error cause with the community! Thank you! 

Best Regards,

Jing

[Eli_r06 · Accepted solution]

Hello! thanks for your answer, I found the error, it was that 124 files had #N/A and power bi doesn´t recognize it.