Help!!! Expression Error

Hi, 

Similar has happenned with me so what I think is, the source doesn't have 'Column18'  and hence the error. (seems, source was changed after you ingest that table in Power BI)

If it is really not there, remove it from query as well:

Updated:

= Table.TransformColumnTypes(#"Promoted Headers",{{"Partner", type text}, {"Loan ID ", type text}, {"Loan Type", type text}, {"Loan Subtype", type text}, {"Low Income", type text}, {"Loan Amount", type number}, {"City", type text}, {"County/Parish", type text}, {"Census Tract", Int64.Type}, {"State ", type text}, {"Zip", Int64.Type}, {"Male/Female", type text}, {"Race", type text}, {"Ethnicity", type text}, {"Loan Count Per Census Tract", Int64.Type}, {"Current as of", type date}, {"Data Pull Date", type date}, {"Column19", type any}})


Side note: if it again says the same error for "Column 19", remove it as well so your step should look like:

= Table.TransformColumnTypes(#"Promoted Headers",{{"Partner", type text}, {"Loan ID ", type text}, {"Loan Type", type text}, {"Loan Subtype", type text}, {"Low Income", type text}, {"Loan Amount", type number}, {"City", type text}, {"County/Parish", type text}, {"Census Tract", Int64.Type}, {"State ", type text}, {"Zip", Int64.Type}, {"Male/Female", type text}, {"Race", type text}, {"Ethnicity", type text}, {"Loan Count Per Census Tract", Int64.Type}, {"Current as of", type date}, {"Data Pull Date", type date}})

Let me know if it helped you.

If this helped, Please kudo this post and mark this as a solution!

Thank you!