Removing unused column from connected sources error

[misen13]

Hi,

I have multiple connections to folders which contain Excel files. I'm trying to remove unused columns from them, but I'm getting the error "Sorry...We couldn't find the column ..." when I try to refresh my file. Is there a solution to this?

Thank you.

[v-lili6-msft · Accepted solution]

hi, @misen13

Here is a similar thread for you refer to, and there are some workarounds mentioned there. Could you go to check if it helps?

https://community.powerbi.com/t5/Desktop/Expression-Error-The-column-lt-ColumnTitle-gt-of-the-table-...

Best Regards,

Lin

[misen13]

That did the trick! Thanks!