Forum Discussion
Mashup container utilizing all cpu resources when using Power Query
I am not sure if this belongs in this section but I will ask anyway. I am trying to import a named range from an Excel binary file into another workbook using Power Query. The binary file which h...
Hi George
any chance of converting the .xlsb to an .xlsx? Power Query performance tends to be a lot better extracting data from an xlsx.
How many rows / columns are in your IMPORT_TABLE?
any chance of converting the .xlsb to an .xlsx? Power Query performance tends to be a lot better extracting data from an xlsx.
How many rows / columns are in your IMPORT_TABLE?
Wyn,
Thanks for responding. The table is approximately 1400 rows and 65 columns.
Unfortunately, converting the file to .xlsx is not an option. Even as a .xlsb file, the file size is around 65MB. Converting it to .xslx would render the file unworkable.
Is there a different solution other than converting the file type?
Any idea why the functionality is drastically different between .xlsx and .xlsb when importing to Power Query?
Thanks in advance.