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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors