Forum Discussion

HoldMyCoconut's avatar
HoldMyCoconut
Frequent Visitor
4 years ago
Solved

New columns in datasource not available in dataflow

We have a few sources where the columns are added very frequently .These columns are not availabe in dataflows , unless we open the dataflow and save it. Is there any way to dynamically import all the columns in the datasource to Dataflow ? I tried to have this done using

#"Cols" = Table.ColumnNames(Source) 

#"Choose Columns"= Table.SelectColumns(Source,Cols) 

but the new columns were still not getting imported without editing the dataflow .

Any help regrading this ?

Thank you 

1 Reply