Forum Discussion

marcorusso's avatar
marcorusso
Most Valuable Professional
8 years ago

Memory leaks in Power BI custom visuals

In the last few days I connected the dots between several requests I received, and I've found that when custom visuals are created and removed frequently in a report, the browser (or the process CefSharp.BrowserSubprocess.exe used by PBI Desktop) grows in memory until it becomes unusable.

The native visuals don't seem affected by that.

Crashing Power BI seems incredibly easy:

  1. Create a table with 10 rows in a new PBIX file
  2. Import the Chiclet slicer custom visual from the store
  3. Create a Chiclet slicer applying the column with 10 rows
  4. Copy and paste the slicer 9 times around the same page
  5. Duplicate Page1
  6. Save the file (just in case)
  7. Open Task Manager and switch back and forth between page 1 and page 2 for a while
    • The process CefSharp.BrowserSubprocess will grow in memory
    • Switch between one page and another will slow down progressively, usually after 2GB of RAM consumed by the process the response time is unmanageable
  8. Publish the file on powerbi.com
  9. Switch back and forth between page 1 and page 2 for a while
    • This time your browser will grow in memory usage...

 

If I use a regular slicer, the issue is not visible. In reality, I see 4-5 KB lost every time I switch between pages, but it's a fraction of the cost of the custom visuals.

I tried with other custom visuals, made by different developers, and I've got the same result.

 

I have seen in Power BI forum several threads related to the presence of the CefSharp.BrowserSubprocess process, but I didn't see an explanation of the reason, which is not really related to that process considering that the issue also happens on a regular browser for published reports.

 

To my eyes, this is some memory leak issue related to custom visuals when the user switch between pages of the same report. But, of course, I could be wrong, so in this case any further information would be useful.

 

Is this something that other noticed?

Any comment from MS?

 

Thanks,

 

Marco

64 Replies

  • embaud's avatar
    embaud
    Frequent Visitor

    I can confirm the issue. Using Chiclet slicer on sveral pages. Each time you switch pages,CefSharp.BrowserSubprocess.exe grows in memory and CPU usage. At some point response time becomes unmanageable and you nedd to restart.

     
    • Anonymous's avatar
      Anonymous
      Not applicable

      embaud, Is there a fix planned for this issue? We are facing similar issue and our report pages have other custom visuals as well, including Chiclet slicers.

       

      The customer finds the report to be unusable, as not all the client computers have RAM > 4GB. The behavior is observed in both IE as well as Chrome.

       

      Regards,

      Ashish

      • v-viig's avatar
        v-viig
        Community Champion

        As far as I know, Power BI Custom Visual API team is still working on this issue.

        We'll update status once we have some news.

         

        Ignat Vilesov,

        Software Engineer

         

        Microsoft Power BI Custom Visuals

        [email protected]

    • v-viig's avatar
      v-viig
      Community Champion

      The primary memory leak was fixed.

      Currently we're working on other methods to reduce memory footprint.

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • ragh1084's avatar
        ragh1084
        Advocate I
        Definitely there is problem with custom visuals. I have an report in which all the visuals load fast except clicklet slicer and card with states.
        I had to use clicklet slicer, because it enforces the user to always select one.
        I had to use card with states in order to display fore color as green when value is greater than zero. Else red.
        All these features are not available in default visuals.
  • iperezlemme's avatar
    iperezlemme
    Frequent Visitor

    Hi Ignat,

    In my case, the problem seems fixed in Power BI Desktop and Power BI Services while using certain browsers (Chrome, Safari and Firefox). But when using IE or Edge, the memory leak persists. 

    I believe the memory footprint is still been worked on, but i'm afraid using both Microsoft's browsers, the memory leak persists. 

    In my case, I detected the same issue Marco reported, but only using PowerApps custom visual (currently in preview mode) and Argis maps. At the time, I found no other custom visuals with the same issue. 

    The main problem is that any of the mentioned browsers release no memory at any time (I left the computer on for 2 hours and memory was still taken). What makes it even worse, is that IE doesn't crash and restart by itself, but I shows an error in the report and stops loading as shown in the images at the end. Edge manages a bit better and reboots by itself.

    Some technical details....

    • Independent of the OS
    • Only occurs in Edge and IE. Couldn't repro in Chrome, Safari and Firefox
    • IE crashes when reaching 1.5GB memory. Edge crashes when reaching 5GB memory (I miss a test here, what occurs when the computer doesn't have that much memory available)
    • It's not exclusive of custom visuals (as far as I am concerned). If you move quickly enough between pages, the browser still increases in memory consumption without releasing any, with the same ending. In this case, IE does release the memory after a while. 

     

     

    Edge Memory Leak in Win10IE11 Memory Leak in Win10IE11 Memory Leak in Win7 

     

    Regards,

    Ignacio

    • v-viig's avatar
      v-viig
      Community Champion

      It looks like this issue might be related to these specific visuals.

       

      Can you share any repro steps?

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • iperezlemme's avatar
        iperezlemme
        Frequent Visitor

        Yes, sure!

        0. Open app.powerbi in IE 11 or Edge

        1. Create a new report (Desktop/Service) with a datasource of your choice, AdventureWorks will do.

        2. Create 2 pages in your report and in one or both pages insert a PowerApp visual or ESRI Maps visual, with the corresponding fields.

        3. Navigate the report going from page 1 to page 2, to page 1, and again. 

        4. If desired, open Task Manager to review how memory incresases without being released at any moment. In IE it'll crash when reaching 1.5gb aprox and Edge 4/5gb aprox. 

         

        Please tell me if you need any more info! 

        Ignacio

  • Anonymous's avatar
    Anonymous
    Not applicable

    Is this being addressed? I am experiencing the same issue.  

    • v-viig's avatar
      v-viig
      Community Champion

      Hi Anonymous

       

      Power BI Custom Visuals API team is working on improving performance.

       

      Can you share any details on when you face the same issues?

       

      Ignat Vilesov,

      Software Engineer

       

      Microsoft Power BI Custom Visuals

      [email protected]

      • gerritK's avatar
        gerritK
        New Member

        Hi v-viig ,

         

        a new guy bothering you for updates...   ;-)

        Any news on this issue? We're currently also in the middle of two proof of concepts with enterprise customers and without solving this performance issue we're probably going to loose against Qlik Sense.

         

        Thanks for your effort & Kind regards,

        Gerrit

  • Hello there, I'm a new user and I already noticed the memory leak "cefsharp.browsersubprocess.exe".

    I'm using Power BI Desktop under Win7 SP1.

    Is there any solution yet?

     

    Thanks.

    • jjesus_fd's avatar
      jjesus_fd
      Frequent Visitor

      Buenas tardes,

       

      Al actualizar a la nueva versión de diciembre de 2019 me sale el error "CefSharp.BrowserSubprocess dejó de funcionar".

      Reinstale versiones anteriores y el error persiste. Actualmente he dejado la versión de diciembre de 2019

       

      La memoria consumida crece al cambiar de página y cuando activo las vista de marcadores hasta cerrarse el fichero. Las visualizaciones personalizadas que utilizo son "chicletslicer" y "textfilter".

       

      Creo que el mayor problema al que me he enfretado ya que todos mis informe están inutilizados por este hecho.

       

      Pido ayuda.

       

      Gracias.

      • jjesus_fd's avatar
        jjesus_fd
        Frequent Visitor

        Este es el consumo de memoria cuando se activa el panel de marcadores. Hasta que se cierra.

         

        Si abro el fichero y voy al panel de marcadores queda inutilizable el informe.