Power BI high CPU and RAM load

[pruskis]

Hello,

Recently we've started working with Power BI. We are running it on HP EliteBook 840 G5's. It was running fine until recently. It doesn't seem to have enough power. CPU goes all the way up, also 16GB of RAM gets filled pretty quickly. Problem is, there's not enough information about what kind of system I should be looking for. Should I be looking for a simple loptop or a desktop workstation? Or server grade equipment is required?

[syvargas]

I am experiencing this issue while working with Kusto data source.  I unchecked Background data and it still runs high on Power Usage repeatedly.

Any ideas would be appreciated.

[v-piga-msft]

Hi @pruskis,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[Anonymous]

Hi @v-piga-msft

I am having similiar problems, I have a really small datasets (the PBI file is 391 kb) and it worked perfectly until just few days ago, I have tried to uncheck the background data. One of my queries come from Excel Online (data imported via WEB function) and that one seems to be causing the problems (I think it started because the excel online suddenly had 999+ columns, all empty. But I have filtered them out, might be that it is still dowloading them all). Do you have any idea what could be wrong? or if it is the column problem, how I can get the data from Excel online and not download all the columns?

[v-piga-msft]

Hi @pruskis,

For your scenario, please check if you have disabled the option under Data load.

There is a similar thread you could refer to.

Reference: https://www.technoblogy.net/solved-powerbi-desktop-taking-too-much-cpu-and-memory/

Best Regards,

Cherry

[Anonymous]

Hi, 

The link is no longer avaibale. Could you revised the content?

[T2]

I had the same question and just checked. Unfortunately, Archive.org doesn't have the site archived and, worse, the domain appears to be compromised. Going directly to the domain (i.e., the URL up to .com) I am hit with "helpful" message with the Chome icon recommending I change my search engine. Not good.

[AdamDel]

certainly worked for me, thanks a lot 🙂

[evalyn]

Hi Adam,

What worked for you? I am also having this issue and any details would help.

[evalyn]

Thanks Adam, I will have a chance to try this out later today. Hope it works!

[Anonymous]

Hi

 I assume you are asking the configuration for deveopment activities.. 16 GB RAM size is good and normal laptop will do for regular work. But the memoery consumption is based on your data size too. Kindly check whether you are dealing with huge dataset. Also check your visualaisation is designed properly.

Thanks

Raj

[pruskis]

Hello,

Recently we've started working with Power BI. We are running it on HP EliteBook 840 G5's. It was running fine until recently. It doesn't seem to have enough power. CPU goes all the way up, also 16GB of RAM gets filled pretty quickly. Problem is, there's not enough information about what kind of system I should be looking for. Should I be looking for a simple loptop or a desktop workstation? Or server grade equipment is required?