Forum Discussion
Data format bug in the matrix
According to the error message provided on the image, it states, "This visual object has exceeded available resources. Try filtering to reduce the amount of data displayed. " The cause of this problem may be the dataset may be too large or complex for a Power BI Pro license.The error may be related to the recent Power BI update in November.
I think you can simplify the query by removing unnecessary columns, filters or transformations that consume too much memory. Reducing the amount of data is also necessary. I think you can reduce memory usage in Power BI by using Power BI Premium and if the dataset is very large, use DirectQuery or Live Connection to query the data directly from the source. If you are using Power BI Premium, request the Capacity Manager to increase the memory limit per query. You can also take a more in-depth look at the document below: how to fix visual has exceeded the available resource. - Microsoft Q&A
I hope I answered your question!
When you mention limitation per query, are you referring to Power BI Desktop or Power BI Service?
Because it wouldn't make sense to limit my own hardware, but rather if it were in the cloud.
- Uzi20192 years ago
Community Champion