Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
homboy27
Helper II
Helper II

Expression.Error: The column 'JOB_LEVEL' of cube 'QUERY' wasn't found. If it was removed from the cu

Expression.Error: The column 'JOB_LEVEL' of cube 'QUERY' wasn't found. If it was removed from the cube you'll need to update the query.

 

I am getting the above error. I dont have the Job level field even brought into this report. Do you know how I can solve it?

4 REPLIES 4
v-yajiewan-msft
Community Support
Community Support

Hi homboy27, hello,AmiraBedh, thank you for your prompt reply!

 

I'm checking how the things are going on about this issue. Whether the answer helps you?

AmiraBedh
Super User
Super User

Even if the JOB_LEVEL column isn't directly included in the report, it might still be referenced in a measure, calculated column, or calculated table.
Go to your "Model" view and review all measures and calculated columns to see if any of them are using JOB_LEVEL.

Open the Power Query Editor and inspect all the steps in your queries. Look for any step that might reference the JOB_LEVEL column.
If you find such a step, either modify it to use a valid column or remove it if it's not needed.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Thank you but that field is not referenced anywhere in my report. Do you know what else can be the issue?

Did you check the filters on the page level or the visual level?

Have you checked Power Query ?


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.