Error Import Excel Files

[ovetteabejuela]

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 · Accepted solution]

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.