Column 'y' in table 'x' cannot be found or may not be used in this expression

[Anonymous]

I have this huge dataset (30M+ rows) and I can't load it into PowerBI Desktop because I get a "not enough memory to complete this operation error". So, I tried deleting an unused calculated column (created in Data view) and then refreshing the dataset, only to see this error. Is there a way to get around this?

Thank you.

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

So what's happening here is that one of the columns you've deleted is used in another column or in an applied step.

so you check check Power query, go through the tables and see where's the error is coming from and solve it by removing the column missing from the code.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Anonymous]

Thanks - Looks like it was used in an another measure so I've changed it.