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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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.

 

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

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

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
Not applicable

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors