locked
Error when reading from Folder in Power Query (Get Data) RRS feed

  • Question

  • When I'm importing a folder into Power Query, i'm getting an error message reading :

    "Power Query Import Folder issue - DataFormat.Error: The input couldn't be recognized as a valid Excel "

    These files are in .xlsx for format. However, if i save all the fils to .xls format, the import folder feature works correctly.

    Is this a known issue and is there a resolution. Sorry, but i could not find a post that was exactly like mine.

     I'm am using Excel 2016 64 bit

    Monday, April 11, 2016 5:08 PM

Answers

  • Can you open the Advanced Editor and paste your query here? It's not clear how you're getting this error, since the "From Folder" formula shouldn't attempt to interpret the file contents.

    Ehren

    Monday, April 11, 2016 5:14 PM