Forum Discussion
Unable to drilldown to lowest level In matrix visual(This visual has exceeded the available resource
Hello team,
Iam using Matrix visual for displaying Profit and Loss line items. We have "15" measures in Values pane and "4"Columns in hireachy. When we drill down to the lowest level its throwing perfromance error. Can anyone please suggest us how to rectify this error other than upgrading to power Bi premium which is impossible in our case.
If needed i can post the main measure we are using for calculating Pnl_line items.
Can anyone please suggest the solution for this issue or any technique to optimize the measure.
Thank you Waiting for updates
Hi, Anonymous
This issue often occurs when a visual has attempted to query too much data for the server to complete the result with the available resources. Your current formula is difficult to optimize further.But sometimes exceeding data point limits and policies can also cause such error. As the error message says, you need filter to reduce the amount of data displayed.
Apply data-point limits and strategies by visual type
When rendering a visual in Power BI, the visualization must be quick and accurate. That requires underlying algorithms configured for each visual type. Visuals in Power BI must be flexible enough to handle different sizes of datasets. Some datasets have only a handful of data points, while other datasets have petabytes of data points. This article explains the strategies used by Power BI to render visualizations.
Matrix
- Rows: Virtualization by using Window of 500 rows at a time
- Columns: Top 100 grouping columns
- Values: multiple values do not count against the data reduction
Best Regards,
Community Support Team _ Eason
1 Reply
Hi, Anonymous
This issue often occurs when a visual has attempted to query too much data for the server to complete the result with the available resources. Your current formula is difficult to optimize further.But sometimes exceeding data point limits and policies can also cause such error. As the error message says, you need filter to reduce the amount of data displayed.
Apply data-point limits and strategies by visual type
When rendering a visual in Power BI, the visualization must be quick and accurate. That requires underlying algorithms configured for each visual type. Visuals in Power BI must be flexible enough to handle different sizes of datasets. Some datasets have only a handful of data points, while other datasets have petabytes of data points. This article explains the strategies used by Power BI to render visualizations.
Matrix
- Rows: Virtualization by using Window of 500 rows at a time
- Columns: Top 100 grouping columns
- Values: multiple values do not count against the data reduction
Best Regards,
Community Support Team _ Eason