Power BI Desktop high CPU and RAM load - Custom Visual

Capono — Tue, 12 Mar 2019 12:39:43 GMT

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

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

topic Power BI Desktop high CPU and RAM load - Custom Visual in Developer

Power BI Desktop high CPU and RAM load - Custom Visual