Forum Discussion
Adding new column in data source to table
Hi, I'm relatively new to power query. I have an excel doc which has a table connecting to a data source which is a .csv file I have added an additional column to the csv file and expected i...
You may remove entire record, which specifies options, at all. Something like
Source = Csv.Document(File.Contents("C:\Test\Test.csv"))Power Query is clever enough to recognise in most cases non-empty columns, default delimiter and encoding. Another story if on next steps you transform your columns somehow, you shall take new column(s) into account as well.