Forum Discussion
Solved
Power Query - Combine Binaries
Hi guys. So ran into an issue lately, I am guessing after recent O365 updates. I have created several models based on the same csv data in single folder, and they work perfectly. Now, creating new mo...
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