msmdsrv.exe bloated to 4.7 G memory usage - what's wrong?

[ovetteabejuela]

Hi Community,

What's wrong with this?

It just started while I was adding slicers, changing colors actually when the PC was put on a halt... 30 minute-worth of work is now hard to recover. Everytime I open the latest file or the recovered file I am getting that(screenshot).

What could have been wrong?

[v-ljerr-msft]

Hi @ovetteabejuela,

Could you try disabling the following options under File > Options and Settings > Options > CURRENT FILE > Data Load to see if it helps in your scenario? 

• Allow data preview to download in the background
• Enable parallel loading of tables

Regards

[ovetteabejuela · Accepted solution]

@v-ljerr-msft hi.

I actually did some research before I posted - so I already did that but it has no effect.

The PBIX file is indeed corrupted - I did everything I could to revive it but I always end up with that surge in memory consumption. So I did what is necessary - start with the latest version that I have(lost hours) it was just funny how it started as I can vividly remember that I was just trying to customize some visuals (changing colors) and boom.

I'm fine now I just have to always remember to always save versions of my work as often as possible.

I will mark this as solved by just redoing the work but not by reviving a recent work.