Hi all
It seems that since a recent upgrade of Power Query (Excel 2013), whenever I expand a table from an Excel data source, Power Query introduces a new Folder named "Transform Binary From..." which contains a subfolder named "Sample Query" and 2 other items. The Subfolder also contains 2 items ("Sample Binary" and "Transform Sample Binary From ...").
I don't recall seeing these in earlier versions (might be me).
Does anyone know why these are there, and can they be avoided somehow? Eg with these, it makes it a bit harder to copy/paste a query from one workbook to another.
Edit: it seems that if I create a custom column using 'Excel.Workbook([Content]), I'm getting the same result without the additional folders.But if someone knows what the difference is, it would be great to understand.
Many thanks for your feedback
Bart
It seems that since a recent upgrade of Power Query (Excel 2013), whenever I expand a table from an Excel data source, Power Query introduces a new Folder named "Transform Binary From..." which contains a subfolder named "Sample Query" and 2 other items. The Subfolder also contains 2 items ("Sample Binary" and "Transform Sample Binary From ...").
I don't recall seeing these in earlier versions (might be me).
Does anyone know why these are there, and can they be avoided somehow? Eg with these, it makes it a bit harder to copy/paste a query from one workbook to another.
Edit: it seems that if I create a custom column using 'Excel.Workbook([Content]), I'm getting the same result without the additional folders.But if someone knows what the difference is, it would be great to understand.
Many thanks for your feedback
Bart
Last edited:
