Help!!! Expression Error

[W2SANC]

Have completed my dashboard and as I go back into my final checks, I found this error and all of my data is gone and the source has the yellow caution sign - error message copied below. on my 4th applied step. (1 - uploaded data source; 2 - navigation and 3 - promote first row to headers; then 4 - change type).

Expression.Error: The column 'Column18' of the table wasn't found.
Details:
Column18

On the "changed type" step is where it goes wonky. See the code from the changet type step below. 

= 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}, {"Column18", type any}, {"Column19", type any}})

I tried re-ordering my steps so all added columns, re-names, and type changes happen before more minor edits (cleaming, trimming, etc) - and that worked in the power query editor. When I applied the changes, all of my numbers (total sales, etc.) were doubled. 

Thanks in advance for any and all help to *actually* fininsh this dang report. 

[v-achippa]

Hi @W2SANC,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Natarajan_M and @InsightsByV for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[InsightsByV · Accepted solution]

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!

[W2SANC]

Hi, I did this and it "fixed" the error, but all of my numbers on the dashboard were doubled (total sales amount, count of sales, etc.) - which was a super weird result. I'm working on that issue now but this was helpful for this specific issue. Thanks!

[InsightsByV]

Glad that it worked, let us know if you need any help regarding this doubling issue.

[Natarajan_M]

Hi @W2SANC , Can you share the entire PQ to understand in detail what's going on?

Thanks