Forum Discussion

RG's avatar
RG
Regular Visitor
9 years ago
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...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    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.

     

MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

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.

 

RG's avatar
RG
Regular Visitor
9 years ago
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.