Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I need help to load data from folder with three files where one has a different column and this column didn't appear in the final report.
I have a folder [C:\Report] and subfolders [Joe, Mike, Paul]:
In each subfolder I have a Excel file as a report.
In 2 files (Joe and Mike) I have just two columns (Product/Sales) and the other file (Paul) I have three columns (Product/Sales/Cost).
I imported the folder and combined the Excel files:
The final report is generated
But, without the column COST.
I need to make appear the column COST.
The column is in Transform File:
But, didn't appear in the report final.
Thanks for any help.
MRBranco
Solved! Go to Solution.
Hi,
Please follow the process shown in this video to append files from multiple folders - https://www.youtube.com/watch?v=yL11ugShdrk.
Hope this helps.
Hi @MRBranco
Please follow the guide from Ashish_Mathur's video, then select "load more" below.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Please follow the process shown in this video to append files from multiple folders - https://www.youtube.com/watch?v=yL11ugShdrk.
Hope this helps.
@MRBranco - That may be tricky. It's probably because the file that had that extra column is not the file that you used for your sample file. Problem may be that if you use it as your sample file, all of your other files will error when loading.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
63 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |