February 3, 2016
I am trying to run a power query to import data from a folder containing 5 monthly files but am getting the following message when I double click on 'Binary' column,
DataFormat.Error: The input couldn't be recognized as a valid Excel document.
when I select one individual monthly file it imports data, any idea what I'm doing wrong.
July 16, 2010
It sounds like you're using the technique for importing CSV or Text files from a folder. The technique for importing Excel files is different.
For Excel files from a folder you must Add a Custom Column and use the Excel.Workbook function.
Then you expand the Table to get the columns from the workbooks.
Most Users Ever Online: 57
Currently Online: clark shao
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas