DataFormat.Error on Excel file (Binary) RRS feed

  • Question

  • Trying to make a query to closed xlsx workbook causes DataFormat.Error (inappropriate Excel file or something like this). PQ shows me a sheet in this file, but in preview (or when tried to load data) PQ shows an error with description Binary

    When this file opened in Excel - PowerQuery works in it as usual and everything is ok. But if file closed and I trying to get data "From file... -> Excel file" I got this error again.

    This is an output format of 1C (very popular in Russia accounting program). If I open it (Excel make no alerts about unappropriate file format), save immediatly, close - then PQ works fine with closed file.

    It causes problems for me because I cannot change file format on source, and opening and saving each file I have to proocess is.... I can write a VBA macro for open file, save etc. but... it is very inconvenient.

    Do this issue has a solution? Where I should look for the source of error?

    Thank for any suggestions

    Thursday, October 22, 2015 1:23 PM


All replies