Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Large datasets render computer unusable

I have a pbix file that has some very large datasets in it. When I attempt to refreshall on that dataset, powerbi merrily goes off and collects all that data... and then pbidesktop and the mashup engine cheerfully consumes the entirity of my CPU and RAM, rendering my computer completely unusable. This is to the point where I cannot even use a separate machine to remotely list processes or kill processes so that I can reconnect to the machine in question. 

 

Obviously this is very frustrating - and doubly so because after physically powering down the machine and turning it back on, the recovery file that pbix has left behind - the first thing it does upon opening is to refresh all. So do I let that complete and risk my computer being unsuable in a few hours, or do I stop it and have no data to work with? This, as one can imagine, is very frustrating.

Status: New
Comments
v-chuncz-msft
Community Support

@moody31415 

 

You may take a look at Optimization guide for Power BI.

moody31415
Employee

Sure, that's great, but why is powerbi rendering my computer inaccessible ok?