The Column "ColumnName" of the table wasn't found

[JohnW]

Hi everyone,

This issue just came up a few days ago and I can't figure out how to fix it.  I have multiple reports that use the same CSV file to run the reports that I build and they are all broke now.  The only thing that I've changed in the CSV file is updating it daily with new data.  I've tried deleting the part where "Columns = 12" but no luck there.  When I do delete the Changed Type it breaks the report completely.  

Thanks!

[camargos88 · Accepted solution]

Hi @JohnW ,

Have you tried to clean the cache ? 

[v-xicai]

Hi @JohnW ,

You may click the step "Promoted Header" under "APPLIED STEP", then go to  the table query to check if the column named "AcadmincSemester" does exist in it. If "AcadmincSemester" column doesn't exist, you may delete the relative code about "AcadmincSemester" in Advanced Editor.

Or the name of  "AcadmincSemester" column may have been changed to "xxxx" in data source, you may find this column using matched column content , and replace the "AcadmincSemester" with "xxxx" in Advanced Editor.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[camargos88 · Accepted solution]

Hi @JohnW ,

Have you tried to clean the cache ? 

[JohnW]

Hi @camargos88 ,  

I hadn't thought of that but I just tried that and unfortunately that wasn't the fix

[camargos88]

@JohnW ,

Is it possible that any of your files does not have this column ?

[JohnW · Accepted solution]

Hi @camargos88 and @v-xicai ,

Thanks for your suggestions on this issue.  It turns out that when I was saving the result as in SSMS, for some reason the option where it is supposed to include the column headers when copying or saving the results somehow unchecked itself.  I just had to recheck it and restart SSMS for it to work again.  Thanks again for the help!