Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Capono
Frequent Visitor

Power BI Desktop high CPU and RAM load - Custom Visual

Hello Power BI Team,

 

recently we are getting high CPU-Usage and RAM-Usage till the report goes blank. This happens even on blank reports with only one visual that has more than 3 categories with 30000 values each. We did not experience that error in the past, we did suffer this issue first in December and we recognized it recently that it is caused by Power BI. (The same works on Power BI Service fine).

 

We are using the latest Desktop Version of February and the latest API of 2.3.0 of Power BI Visual Tools for Custom Visuals.

 

On a deeper analyse of this issue, we found out by building a completely new visual that the problem is coming from the configuration in Power BI in capabilities.json, if using the data reduction algorithm on smaller data sets then 30000 it works fine otherwise not, further using different categories causes problems which did not occur in the past.

 

I have put a completely empty report with the visual in it where you can see the high CPU Usage. Which is caused by CefSharp.BroserSubprocess  

 

image.png

The issue is reproducible by increasing the number of categories and using categories with distinct values of 30000.

 

{
    "dataRoles": [
      {
        "displayName": "Number of cases",
        "name": "count",
        "kind": "Measure",
        "requiredTypes": [
          {
            "integer": true
          }
        ]
      },
      {
        "displayName": "Attributes",
        "name": "category",
        "kind": "Grouping"
      }
    ],
    "dataViewMappings": [
      {
        "categorical": {
          "categories": {
            "bind": {
              "to": "category"
            },
            "dataReductionAlgorithm": {
              "top": {
                "count": 30000
              }
            }
          },
          "values": {
            "select": [
              {
                "bind": {
                  "to": "count"
                }
              }
            ]
          }
        },
        "conditions": [
          {
            "count": {
              "min": 0,
              "max": 1
            },
            "category": {
              "min": 0,
              "max": 5
            }
          }
        ]
      }
    ],

 

Hope someone can help, 

 

Since this is causing inconvenience.

 

With Regards

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.