Error when transforming data

[kshotts]

I am transforming some data on a large list from sharepoint.  I got this error.  Can anyone translate? I would also like to mention that two of my records column will not expand to extract the data I need.

= let
tableWithOnlyPrimitiveTypes = Table.SelectColumns(Source, Table.ColumnsOfType(Source, {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 = "The type of the value does not match the type of the column.", Detail = v], fieldTypes{i}})
in
Table.TransformColumns(Source, pairs)

[Syndicate_Admin]

The table data is based on "FROM date and to date". So, while giving web link, all the branch and region name is coming but total is Zero due to data is not loaded while giving the link

[Anonymous]

Hi @kshotts ,

Any updates?

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @kshotts ,

I am transforming some data on a large list from sharepoint.  I got this error. 

So please share the error message with some screenshots to help us clarify your scenario.

And  since any transformations to your data will show in the Applied Steps list, you could click there to find the wrong transformations 

Refer to:

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

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

[lbendlin]

What would you like translated?  You posted some Power Query code that seems to check a source table for structural consistency.  What is the actual error message that you got?