Forum Discussion
Power Query - Combine Binaries
Since the November 2016 update of Power BI Desktop, multiple object are created.
I provided an explanation in this topic.
My suggestion would be to verify your Transform Sample Binary from Data query:
by default, for csv-files the first step Source contains the function Csv.Document, including specifications for splitting values.
The next step is Promote Headers and the 3rd and last step is Change Type.
Since the November 2016 update of Power BI Desktop, multiple object are created.
I provided an explanation in this topic.
My suggestion would be to verify your Transform Sample Binary from Data query:
by default, for csv-files the first step Source contains the function Csv.Document, including specifications for splitting values.
The next step is Promote Headers and the 3rd and last step is Change Type.
- Hi thanks for your reply. I failed to point out the issue was in excel version of PQ. But given the updates to O365, your solutions are highly relevant. I'll look through those and the 21min video to better understand the sample binaries. Thank you so much.
I'm not a fan of the combine.binaries-way at all. You can still to the "old-fashioned-way" via an added column like described in here for example: http://community.powerbi.com/t5/Desktop/Retain-file-name-column-when-using-Folder-as-a-data-source-Power/td-p/22851
