Forum Discussion

W2SANC's avatar
W2SANC
Icon for Helper II rankHelper II
5 months ago
Solved

Help!!! Expression Error

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 app...
Need Help
  • InsightsByV's avatar
    InsightsByV
    5 months ago

    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!

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
5 months ago

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