May 1, 2020
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.
July 16, 2010
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.