Forum

Adding a new data c...
 
Notifications
Clear all

Adding a new data column to existing Data that populates a Power Query

2 Posts
2 Users
0 Reactions
167 Views
(@rachael-cox)
Posts: 1
New Member
Topic starter
 

Hello- I have a folder which contains 8 csv files which feed my Power Query and ultimately create my dashboard. Recently I was requested to add an additional field of Data, so I added a Column (Column x- Cost Centers) to each of my CSV files, in hopes that when I refreshed my Dashboard, I would now see this Data in my Data set, that I could work with and create Pivot Tables? However, this new Data set, is not pulling through? Any advice on how I can add to existing CSV files and have it populate in my already established Query? I have attached a screenshot of my Data and the field I am attempting to add, along with a screenshot of my Mcode. Thanks so much.

 
Posted : 01/05/2020 11:12 am
(@mynda)
Posts: 4762
Member Admin
 

Hi Rachael,

Open the advanced editor for the Transform File query. Here you will see the Source = Csv.Document function has a parameter that specifies the number of columns. In your case it should say Columns=10. Delete this argument and the comma that follows. This will default to the query getting all of the columns.

Mynda

 
Posted : 01/05/2020 9:23 pm
Share: