Forum Discussion

David365's avatar
David365
Copper Contributor
Oct 09, 2019

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

excel

3 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 09, 2019

    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.

    • David365's avatar
      David365
      Copper Contributor
      Oct 21, 2019

      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.

Resources