Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

New columns from data source are missing in dataflow

I have a dataflow that's using OData feed as a data source. The data source was updated with a new column so I refreshed my dataflow expecting to see this new column, but it did not show up.   Edit...
Dataflow
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    It can be as simple as the difference between Table.SelectColumns() and Table.RemoveColumns()

     

    Check your Power Query code for any transforms that may filter columns.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

It can be as simple as the difference between Table.SelectColumns() and Table.RemoveColumns()

 

Check your Power Query code for any transforms that may filter columns.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    It looks like this was it. I had a step that removes columns of

    type table, type record, type list, type nullable binary, type binary, type function

     but the missing column was not one of those types and still showed up in the editor after this step was applied.

     

    I'm still not fully understanding why this solved the issue but the issue is now fixed, thank you.