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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
smjzahid
Helper V
Helper V

Expression Error The column of the table was not found in Dataflow

I have a dataflow which has multiple transformation steps, and my one of the steps (shown belwo) named "Invoke Custom Function", now throws an Expression Error, 

 

I did tried to go through the entire query by copying it from the ADVANCED EDITOR and pasting it in notepad and used the (FIND) functionality of notepad to look for the column named EWR_Planner, but this column does not exist in the entire query. 

 

How do I get rid of this expression error from my dataflow

 

image.png

 

3 REPLIES 3
smjzahid
Helper V
Helper V

Hi @SteveCampbell  Thanks for your reply, Yes, I can see one custom function (see below), but I cant see the column thats cause the error, EWR_Planner,

 

How do I rectify this, Please help

smjzahid_0-1603433847821.png

 

Hi @smjzahid ,

Could you please share the applied codes of the related query in Advanced Editor in order to make troubleshooting? Thank you. In addition, you can review the following similar threads and check whether their solution can also help resolve your problem.

Power BI - "Expression.Error: The column of the table wasn't found

Power Query: Preventing "The column of the table wasn't found" error

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SteveCampbell
Memorable Member
Memorable Member

This runs a custom function, which will be another query. If you look for the name of this function in the formula bar / advanced editor, you should see it in the queries on the left.

 

Here you will find the column throwing the error



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.