Expression.SyntaxError: A Comma cannot precede a RightBrace.

Question

= Table.TransformColumnTypes(#"Promoted Headers",{<!-- -->{"Student", type any}, {"Last Name", type text}, {"First Name", type any}, {"Unit", type any}, {"POD", type text}, {"School District", type text}, {"School", type text}, {"Grade", type any}, {"Special Ed Code", }, {"1st Indate", Type any} type text, {"Date in H2", type any}, {"IEP start", type any}, {"IEP end", type any}, {"ETR", type type text}, {"Services", type text}, {"Column16", type text}, {"Column17", type any}})

I keep getting error
Expression.SyntaxError: A Comma cannot precede a RightBrace.

Answer 1

Looks like "Special Ed Code" is missing the type after its comma.

Power Query is no longer supported here on Q&A. In the future, please post your questions over on https://aka.ms/PQCommunity instead.