Combine Binaries renders null even if all files has same column names

[Anonymous]

When I do combine binaries, only the first two files have the complete fields while the rest have null for the DEALSIZE column.

What could be the reason why this is happening?

Also, related question, what is the "Sample Query" for? And how exactly does combine binaries work..

The documentation in Power BI doesn't explain much.. Or at least, I don't understand it much. I'm still a beginner user.

Thanks!

[MarcelBeug · Accepted solution]

Probably the other files have a different layout, like additional/missing columns or columns with a slightly different name (note that Power Query is case sensitive, so e.g. "DealSize" is not the same as "DEALSIZE").

This video explains how the combine binaries functionality works (and what is wrong in my view with regard to data typing in this perspective; this may be a bit too much information at this moment).