Solved: Error Import Excel Files

ovetteabejuela · ‎03-24-2017

Hi Community,

I am trying to isolate an error, so

1. I started with a blank PBIX file.

2. The usual Get Data (from folder)

3. Issues an Excel.Workbook([Content]) command to select a particular sheet (only filtered 1 particular sheet)

4. Clicked on Expand Binary to work on Transformations/Cleansing

5. Encountered an error and the error was:

MarcelBeug · ‎03-24-2017

Without code, I can't tell what exactly is going wrong, but it looks like you are confusing the old "Combine Binaries" method with the new version that was introduced with the November 2016 upgrade,

Try and skip step3 as I illustrated in this video which I linked already in a reply to one of your previous posts.

Specializing in Power Query Formula Language (M)

View solution in original post

MarcelBeug · ‎03-24-2017

Without code, I can't tell what exactly is going wrong, but it looks like you are confusing the old "Combine Binaries" method with the new version that was introduced with the November 2016 upgrade,

Try and skip step3 as I illustrated in this video which I linked already in a reply to one of your previous posts.

Specializing in Power Query Formula Language (M)