- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I am pulling Data from a folder of Excel files, but want to add a new column to those Excel files
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It can be closed. I am unable to understand where to look in my case based on the suggestions provided.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It can be closed. I am unable to understand where to look in my case based on the suggestions provided.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Dane Belarmino | Microsoft MVP | Proud to be a Super User!
Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I am guessing I am looking in the wrong place as I do not see that syntax anywhere in mine for this:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Dane Belarmino | Microsoft MVP | Proud to be a Super User!
Did I answer your question? Mark my post as a solution!
"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sorry, I am not understanding. I will get back to Google searches on this one to see what I can find.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you. I will take a look at this and see if I can figure it out based on this information. Very much appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 01-17-2024 02:00 AM | ||
01-29-2024 08:05 AM | |||
12-18-2023 08:22 AM | |||
10-25-2023 12:05 PM | |||
Anonymous
| 08-17-2023 03:15 AM |
User | Count |
---|---|
141 | |
115 | |
82 | |
63 | |
48 |