Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Expression.Error: The column 'Column_name' of the table wasn't found. Details: Column_name

Hi Everyone,

I have merged two source tables and made one result table. then i removed unnecessary columns from source tables for optimize the performance

 

But ended up with "Expression.Error: The column 'division' of the table wasn't found.
Details:
division"

 

Capture.PNG

 

Can someone help me solve this ?

 

Thanks in Advance,

Mohideen

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Syndicated - Outbound

Hi @Anonymous ,

 

Either delete the reference to [division] in the M code here:

BA_Pete_0-1665663120600.png

 

OR...

 

Go back through your query steps and adjust them to ensure that the [division] column exists in the table at the step before your reorder columns step.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
BA_Pete
Super User
Super User

Syndicated - Outbound

Hi @Anonymous ,

 

Either delete the reference to [division] in the M code here:

BA_Pete_0-1665663120600.png

 

OR...

 

Go back through your query steps and adjust them to ensure that the [division] column exists in the table at the step before your reorder columns step.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




avatar user
Anonymous
Not applicable

Syndicated - Outbound

Hey @BA_Pete..,it helps!!

Thank you so much 💙

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 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.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)