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, Took a look at the article and didn't find a resolution to my specific challenge. I've attached a detailed workflow that should also give you the information you requested. Let me know if you need more and again thanks for your help.
Hi Corey
I've pulled together a step by step guide of what you need to do in the attached excel file
(my screen shots are from Power BI desktop but it should be the same for Excel)
- 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
I've just downloaded the latest version of Power Query into Excel 2013 and the source cog is showing on my version?
What version of Excel and Power Query are you using?
- Hi Wyn, I do see a new version out here, as of 03/01, and have downloaded it. This version is much better, but the process is still not as streamlined as before. With your help and instructions, I have the latest version incorporating the modifications you provided and I am back up and running. I really appreciate all of the help! Regards, Cory
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)
