cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
charliedata
Responsive Resident
Responsive Resident

Error message regarding missing column

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?

 

charliedata_0-1630425347595.png

 

1 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.

View solution in original post

5 REPLIES 5
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

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. 

@charliedata 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".


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

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.

@charliedata That's a weird one!


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors