Forum Discussion
Power Query & ODBC
Power Query works with Excel binary files extremely slow and in background uses totally different (and limited) connector compare to ones for .xlsx files. Even if that's the same entry point From File->From Excel workbook.
You may try From Database->From MS Access database, select binary file and Transform - result will be the same since same mechanism uses both for binary files and MS Access database.
I don't think ODBC helps, however didn't test myself. Better to save file as .xlsx before query it - if that's possible.
Power Query works with Excel binary files extremely slow and in background uses totally different (and limited) connector compare to ones for .xlsx files. Even if that's the same entry point From File->From Excel workbook.
You may try From Database->From MS Access database, select binary file and Transform - result will be the same since same mechanism uses both for binary files and MS Access database.
I don't think ODBC helps, however didn't test myself. Better to save file as .xlsx before query it - if that's possible.
SergeiBaklan Many thanks for the information! I tried to connect to the binary file via MS Access Database and this seems to have helped so thanks ever so much for the suggestion! 🙂
- really?!? Power Query is slower on binary files? I thought 1 of the advantages of binary files was to improve performance. Learning something new everyday.
