I am pulling Data from a folder of Excel files, but want to add a new column to those Excel files

[ChrisAZ]

So I have set up my model to pull from a folder that contains different CSV file exports from an external platform. Since building the model, I want to have those exports include another column, but PowerBI does not seem to like that or know what to do with it when I try this. Do I have to recreate that whole source in my model with the new format, or is there a way to adjust this so it works inside of PowerBI with what I already have configured? Thanks!

[Anonymous]

Hi, @ChrisAZ 

May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

If it hasn't been resolved yet, please share more details about the issue you're having and we'll do our best to help you solve the problem you're having.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ChrisAZ · Accepted solution]

It can be closed. I am unable to understand where to look in my case based on the suggestions provided.

[danextian]

Hi @ChrisAZ 

It could be due to a variety of different reasons:

• expcilitly selecting columns by doing a remove other columns
• the connection limits the number of columns and/or the columns to connect to

If you're using the GUI to combine the files:

• the specific  number of columns is automatically determined from the sample file. Removing this removes the limit.
• The columns to connect to are determined from the sample file using the code highlighted below.
  
• You need to remove that step and re-expand the tables.  Click to load more to show all columns
• 

[ChrisAZ]

I am guessing I am looking in the wrong place as I do not see that syntax anywhere in mine for this:

[danextian]

The list of columns to expand is based on the transform file but the actual expanding the columns step happens in a different query which is the same as the folder name you first connected to it.

[ChrisAZ]

Sorry, I am not understanding. I will get back to Google searches on this one to see what I can find.

[ChrisAZ]

Thank you. I will take a look at this and see if I can figure it out based on this information. Very much appreciated!

[WishAskedSooner]

Do you have a Table.SelectColumns Step in your PQ modules? If so, then you will need to edit that if new columns show up in the CSV. Otherwise, the Table.SelectColumns Step will always filter out any new columns.

If that is not the problem, then you need to be more specific about what error you are getting.

[ChrisAZ]

Pardon my ignorance, but where would I find that? I am not finding anything like that when I go into my Transform Data section of my model. Thanks.