PowerBi Crashing and slow

[Anonymous]

I have a PowerBi set up with 47 queries of which around 30 of these are pulling data from excel spreadsheets located on a OneDrive, I cannot refresh or edit queries without the PowerBi crashing which I imagine is due to having so many queries. I am running PowerBi 64 bit and have 8gb ram (which is being maxed out).

Is there anyway to optimise this? Each of the excel spreadsheets are around 6 columns, 200 rows and the size of the actual PowerBi is only 1.5mb. 

[v-lili6-msft]

hi @Anonymous 

Try the latest version and please keep the same bit with your system.

Regards,

Lin

[amitchandak]

While you wait for experts to answers. Just check you have virtual memory allocated on your system. Try that if it can be the same size as RAM.