Home

Mashup container utilizing all cpu resources

George Bonanza
Occasional Contributor

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

Related Conversations