Forum Discussion
Combine files (Binary) Missing rows
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!
3 Replies
- lbendlinSuper User
Did you know that you can just use "&" to combine the files (assuming each of them has their own query)?
- Greg_DecklerCommunity Champion
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".