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.
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?