heavy pbidesktop.exe processing

[Anonymous]

Hi

I traced an issue i faced with high processing consumption of pbidesktop.exe

My config :

    - Intel Core i5, CPU@2.60GHz

    - RAM 8Go

    - os 64bits / Processor x64

    - PBI version = 2.62.5222.601 64-bit (september 2018)

    - allow data preview option deactivated

So when I run a pbix file (not a blank one : size 200 meg), the process PBIDesktop.exe:
    - soars during opening at 90-100% -> this is ok
    - then it goes back down and flaten at 50% without me doing anything in the tool

In the past, on my old computer (Windows7), I observed that kind of greedy process but it was the "Mashup Evaluation Container".

Now on Windows10, with a late version of PowerBI, the Mashup process seems to be ok.
But the PBIDesktop.exe bothers me.

So this morning:
    - I did run my pbix.exe
    - the processor got stuck at 50%
    - my computer fans go like crazy
    - don't like that, I close powerbi
    - the processor immediately drops below 10%
    - I restart the same file
    - the processor goes up to 50% (while I still do nothing with the tool)
    - so i wait (complaining for my fans)
    - after 20 minutes (!!), it finally settles down and drops to 10%
    - last check : close powerbi and restart
    - the process remains at 10% (pffeew)

So it's like it's performing some kind of optimization or I do not know what.

As long as it doesn't get to the end, the task runs.

And when finished, it eventualy calms down.

Do you know what is going on ?

I don't have that kind of behavior on all my pbix.

Thanks !

Stephane

[v-piga-msft]

Hi @Anonymous,

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,

well problem not solved but it does happen only once in a while.

Didn't have time to explore & audit my file so it is still a mystery for me...

I will mark your answer as solution though.

Thanks

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Normally, the pbidesktop.exe process slowly may caused by many factors, such as large data source, complex queries and dax expressions and so on. Please check if your pbix file hit one of the factors.

In addition, you could disable data previews to download in the background under File>>Options and Settings >>Options>>Data load>> Allow data previews to download in the background.

In addition, you'd better install the latest version of Power BI Desktop.

Best  Regards,

Cherry