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, 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 Cory Barnes, I get the same issue as you whether I use the older version of Power Query or the new one. Can you send a screenshot of the original M code from the Power Query Advanced editor for the Query that used to work OK Thanks

Just a follow up to my earlier response. It looks like the text file is fixed width. I pulled it in using the following steps (See attached image and file) Note: I didn't change the data type column in the last step as my system isn't set up for US format

Hi Wyn, Thanks for your response. The challenge I am having is related to importing multiple text files (same structure and format as the previous attachment) and trying to subsequently consolidate them. I do not have the original code from the previous version as my machine crashed recently (which is why I had to install the latest and greatest version of Power Query). I've attached the previous documented steps I used previously, that of course are no longer working with the new version. This should hopefully give some insight into the full process. Although the overall flow is completely different, my primary challenge is the omission of data in the text file which of course drives the numbers off when consolidating the file. Thanks for looking at this with me.

Hi Cory Can you send me a screenshot of the editor window with the queries expanded (see circled items)So I can confirm what is happening when you try and consolidate the CSV files If you do have the new combine binaries process it is defnitely more confusing for simple combinations. It is bettter however for more complex combinations (which will actually help you!) From reading the document you provided it seems that the 3 separate steps can actually all be done in Power Query automatically now Unfortunately I don't have the latest update to Excel with the new combine binaries installed on my machine (client compatabilty issues). However here's a screenshot from Power BI Desktop which does the same thing. I think the layout on the left hand side will look similar to what you have. Let me know if it is similar Thanks

Power Query | Combining binaries results in lost data from text file

Wyn Hopkins
MVP
Mar 16, 2017
Just a follow up to my earlier response.

It looks like the text file is fixed width.

I pulled it in using the following steps (See attached image and file)

Note: I didn't change the data type column in the last step as my system isn't set up for US format
Text Fixed Width Demo.xlsx122 KB
- Cory Barnes
  Copper Contributor
  Mar 16, 2017
  Hi Wyn,
  
  Thanks for your response. The challenge I am having is related to importing multiple text files (same structure and format as the previous attachment) and trying to subsequently consolidate them. I do not have the original code from the previous version as my machine crashed recently (which is why I had to install the latest and greatest version of Power Query). I've attached the previous documented steps I used previously, that of course are no longer working with the new version. This should hopefully give some insight into the full process. Although the overall flow is completely different, my primary challenge is the omission of data in the text file which of course drives the numbers off when consolidating the file. Thanks for looking at this with me.
  Instructions for Consolidation of Daily Sweep Reports.docx15 KB
  - Wyn Hopkins
    MVP
    Mar 16, 2017
    Hi Cory
    
    Can you send me a screenshot of the editor window with the queries expanded (see circled items)
    So I can confirm what is happening when you try and consolidate the CSV files
    
    If you do have the new combine binaries process it is defnitely more confusing for simple combinations. It is bettter however for more complex combinations (which will actually help you!)
    
    From reading the document you provided it seems that the 3 separate steps can actually all be done in Power Query automatically now
    
    Unfortunately I don't have the latest update to Excel with the new combine binaries installed on my machine (client compatabilty issues). However here's a screenshot from Power BI Desktop which does the same thing. I think the layout on the left hand side will look similar to what you have.
    
    Let me know if it is similar
    
    Thanks
Wyn Hopkins
MVP
Mar 15, 2017
Hi Cory Barnes,

I get the same issue as you whether I use the older version of Power Query or the new one.

Can you send a screenshot of the original M code from the Power Query Advanced editor for the Query that used to work OK

Thanks

Forum Discussion

Power Query | Combining binaries results in lost data from text file

Share

Resources