I am trying to import a named range from an Excel binary file into another workbook using Power Query. The binary file which houses the data I am trying to import is rather large, 75 worksheets or so. When I try to run the following code in Power Query the mashup container eats up all the cpu resources.
Excel.Workbook(File.Contents("c:\user\desktop\File.xlsb"), null, true){[Name="IMPORT_TABLE"]}[Data]
I have tried disabling the "Allow data preview to download in the background" option in the "Data Load" section as I have seen this suggested as a possible solution. However, this did not fix my problem.
Any other suggestions that might help to correct this issue?
Thanks in advance
