Error message regarding missing column

[Anonymous]

In a dataset PBIX I'm getting an error message regarding a missing column, and (aside from the column not being there!) I can't figure out what's causing it. The column is a grouping of another column that was used previously, not a permanent feature of the dataset.

There are no visuals in the report that use this grouped column. And the detailed error message doesn't give any simple indication about what's causing the issue.

Anyone have an idea what's happened here?

[Greg_Deckler]

@Anonymous Do you have a calculated column or measure that references that column? 

[Anonymous]

Hi @Greg_Deckler - thanks for the suggestion, appreciate your help. There's no DAX reference to this column, either in a measure or calculated column. It's baffling. 

[Greg_Deckler]

@Anonymous Hmm...I don't suppose you can share the PBIX?

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Anonymous · Accepted solution]

Hi @Greg_Deckler 

I tried removing the underlying column (that had been grouped) and this seemed to eliminate the error. The underlying column wasn't being used so it was an acceptable solution.

Appreciate you offering your time to help me on this.

[Greg_Deckler]

@Anonymous That's a weird one!