Combine files (Binary) Missing rows

[Anonymous]

Hi All,

I'm having problems with the Combine Files (Binary) feature, I'm trying to combine 3 files with the same column structure and 200 lines long each. Once I apply the feature of combine them, just two of them are shown complete (200 lines each) but the third one just bring me up 10 lines, so I end up with a table of 600 records instead of 600. Has anyone seen this before? The transformation steps are happening in the Transform Sample File.

The way I temporary fix it is getting into the file that isn't showing all the records and edit a cell (any cell) undo it and save it back. With this, I just refresh the query with the combined files and now it showing me the complete 600 rows. Is like if I need to "activate" the workbook that isn't working. 

Am I doing something wrong?

Thanks!

[Greg_Deckler]

@Anonymous - This sounds really odd. Any chance you can share the workbook(s)? You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[amitchandak]

@Anonymous , refer if these can help

https://community.powerbi.com/t5/Desktop/Combine-CSVs-from-Folder-Separate-Function/td-p/114609

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries

[lbendlin]

Did you know that you can just use "&"  to combine the files (assuming each of them has their own query)?