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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
2 | |
2 | |
2 | |
2 |