Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Machine hangs when opening some power bi reports

Recently my PC is crashing to the point of having to restart it, to analyze the process monitor what was causing it noticed that the Analisy services process that runs alongside the bi power was consuming over 5 gb of ram. to analyze why this be happening not found an answer, this problem happens exporadica form, and any report, whether small or large, did cleaning in my machine and reinstalled the powe bi anyway and the error persisted.

 

Any suggestions on how I can solve this problem?

 

Note: this error had never occurred before and my PC has 8gb of ram and i7 3.0 ghz

Need Help

9 Replies

  • wonga's avatar
    wonga
    Icon for Continued Contributor rankContinued Contributor
    10 years ago

    Sounds like a potential memory leak in one application or another. I'd assume you tried restarting your computer to clear out your RAM or whatnot.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Yes, I did all the standard procedures as described above and as informed the process that is consuming is Analisy services, the question is why sometimes it consumes all this memory and not others? and how to avoid it?

      • andyclap's avatar
        andyclap
        Icon for Advocate IV rankAdvocate IV
        4 years ago

        Power BI runs a version of SQLServer Analysis Services behind the scenes which is a server optimised app, not a desktop app - it assumes it's the only thing running on your machine and so doesn't handle low-memory conditions very nicely.

        Best to increase your RAM to 16GB+ if you're wrangling large reports.

  • Vicky_Song's avatar
    Vicky_Song
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    Anonymous, several questions with which I can better understand your scenarios:

     

    1). Did you ever installed windows updates or something like that on your computer?

    2). Do your Power BI reports connect to Analysis Services? If so, with Import Data or Direct Query?

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      All the machine updates have been made and I am the most current version of power bi installed and I always use and only importing data never DirectQuery

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Vicky_Song wonga

       

      in some tabs I have a great report put even making several filters the error occurs as you can see in the image detail that only by opening the flap and get out of it before the data is displayed ja error occurs

       

      • akjana's avatar
        akjana
        Icon for Power BI Team rankPower BI Team
        10 years ago

        Anonymous, did it sporadically start on your machine or was it a specific Desktop update after which you are seeing this?

        Also does this reproduce for specific reports/tables or just even on an empty/simpler model. In the screenshot, you have a quite some tables in your model.