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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.