Adding new column in data source to table

[David365]

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 it to appear when I refreshed the connection to the data source but it hasn't.

How to i add the additional column?

Any assistance would be greatly appreciated.

Thankyou

[#2]

@David365 

Hi David

In Power Query, you can change the number of columns to be loaded

[#3]

@David365 

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.

[#4]

@PascalKTeam Thankyou this was really hepful. Exactly what I needed. Took me a couple of mins to figure out I needed where I needed to edit it....... didn't have 'Forumla Bar' enabled under 'View'. Got there in the end.