Error: "Expression.Error: The column 'Column Name' of the table wasn't found" For existing Column

[drorli]

Hi,

The below is driving me crazy! I have a table with an existing column ("Issue key"). I know it exists since I filter empty and select distinct on it ...

Still, when trying to buffer the table (or Group By another column) I get an error that the column does not exits.

Any Idea?

let
   Source = ALL_ENTITIES,
   #"Issue Type as text" = Table.TransformColumnTypes(ALL_ENTITIES,{{"Issue key", type text}}),
   #"Remove Empty Issue Type" = Table.SelectRows(#"Issue Type as text", each [Issue key] <> null and [Issue key] <> ""),
   TEST = Table.Buffer(#"Remove Empty Issue Type"),
   #"Grouped Rows" = Table.Group(#"Remove Empty Issue Type", {"Project Code"}, {{"Latest Update Date", each List.Max([Updated]), type nullable date}})
in
   #"Grouped Rows"

Error:

[drorli · Accepted solution]

Problem solved. It was unrelated, in obtaining the data for '

ALL_ENTITIES

[shafiz_p]

Hi @drorli  This simply means that the steps don't have any column named "Issue key". Please try to check step by step and make sure its presence. Since, you have not provided any data, it is not possible to check the root cause. If you want community to check, please provide data.

[drorli]

Thanks @shafiz_p . Unfortunatly, it is not that simple.

This row, works without issue:

#"Remove Empty Issue Type" = Table.SelectRows(#"Issue Type as text", each [Issue key] <> null and [Issue key] <> "")

This is proof that column [Issue key] exists.

The next row does not explicitly mention column [Issue key] at all, I just ask:

TEST = Table.Buffer(#"Remove Empty Issue Type"),

Still, it complains that "The column 'Issue key' of the table wasn't found"

So, it is something deeper ...