Home

Mashup container utilizing all cpu resources

Highlighted
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
RDS 2019 limit resources
renasankarunakaran in Windows Server for IT Pro on
1 Replies
Resources attached to Assignments won't open
MrMearns in Microsoft Teams on
0 Replies
Container Instance CPU setting
Werner Donné in Compute on
3 Replies
Bug in translation of a literal
María José Pedreira in SharePoint on
2 Replies