Forum Discussion
Power Query | Combining binaries results in lost data from text file
This is only since the most recent Power Query update. I've attached a screenshot of what Power Query displays as well as an attachment of the raw data file being consolidated. Please advise.
Hi Wyn, Are you importing a single text file or multiple (this is what I am trying to do for the consolidation)? I get the options you reference when importing a single file but not when importing multiple text files from a folder. There is no gear even present.
Hi Corey, yes I'm combining from a folder
Try replacing the line of code in the formlua bar with this (it may be that the Power BI desktop version i'm using is not consistent with your version of Power Query in Excel). If that's the case then unfortunately I'm not going to be of much further help
= Csv.Document(#"Sample Binary Parameter1",7,{0,13,36,52,74,88,107},null,1252)