New columns in datasource not available in dataflow

[HoldMyCoconut]

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 

[v-zhangti · Accepted solution]

Hi, @HoldMyCoconut 

Please refer to the following link, hope it can help you.

https://community.powerbi.com/t5/Service/New-Column-in-PBI-Dataflow-not-displaying-in-Dataset/m-p/24... 

https://community.powerbi.com/t5/Service/New-column-added-to-Dataflow-not-displaying-in-Dataset/m-p/... 

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-features-limitations 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.