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

[KMondrathi_2022]

Hi All, 

We are struggling to resolve this issue. We have changed Data source details from enviornment to another. The old environment details we shouldn't use anymore. This entire report is based on single view and some query subjects are working fine with same view. But, when it comes 3rd Query subject (as per screen shot) i'm getting this error Expression.Error: The column 'Column1' of the table wasn't found.

I have tried multiple options but nothing is working out. Can someone help me out how to resolve this issue. 

Note: we have to modify this report only and we shouldn't import new table and change because there are couple of reports facing same issue. 

Thank you In advance. 

Regards, 

Krishna M

[mahoneypat · Accepted solution]

Have you tried deleting that final Rename Columns step? It references "Column 1", and it looks like you already have an "Alert_Desc" above.

Pat

[Syndicate_Admin]

Hello @Syndicate_Admin can I contact you via virtual call? I am facing similar issue.  If you can help me fix the issue. 

[mahoneypat · Accepted solution]

Have you tried deleting that final Rename Columns step? It references "Column 1", and it looks like you already have an "Alert_Desc" above.

Pat

[mdelee]

Hey, I'm having this same issue. I can set up a teams call to show you. I can pay for your troubles as well. Should only take about 5 minutes. My email is michael.delee9@gmail.com please reach out when you can 

[KMondrathi_2022 · Accepted solution]

Thank you Pat. I have tried your solution. We were not having data in the Table and once we load data into the table just refresh table has resoluted my issue. However, your solution was great and Thanks Again.