New columns from data source are missing in dataflow

[Anonymous]

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.

Editing the dataflow on the web I can see this new column in the power query editor but if I try to import this dataflow into a new pbi file it's not there. I realized that the power query editor on the web has about 15 more columns than the power query editor on Power Bi desktop after importing this dataflow.

Is there any explanation for the discrepancy between the columns in the dataflow power query editor on the web and actually importing the data into a pbi file?

Thanks

[lbendlin · Accepted solution]

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]

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.