Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
kostask
Helper II
Helper II

Combining files from folder data source, doesn' t produce all columns expected

Hi guys,

I use as datasource a folder which i created on One-Drive

The CSV files that exist in the file have some common named columns and some are not.

After auto combining, my final query doens' t have all the columns of all the files but reproduced some of them.

So the first file has A,B,C,D columns, the second A,B,D,E  and the third A,C,D,F

I expected the new query to have A,B,C,D,E,F columns, but no, some are missing

Is there a work around i can follow?

Thank you!

 

Kostas

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

Please see this video on how to use Table.Combine to append those tables from each file differently.

 

You are getting files from folders the WRONG way in Power BI!! Here is how to fix it- Part 1 - YouTu...

 

Pat

Microsoft Employee

View solution in original post

1 REPLY 1
ppm1
Solution Sage
Solution Sage

Please see this video on how to use Table.Combine to append those tables from each file differently.

 

You are getting files from folders the WRONG way in Power BI!! Here is how to fix it- Part 1 - YouTu...

 

Pat

Microsoft Employee

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors