Forum Discussion
Visual Exceeding Available Resources
Hi everyone, A user has recently started getting an error "The visual has exceeded the available resources. Try filtering to decrease the amount of data displayed". The error mentions a few solution...
GilbertQ
Super User
Super UserHi there
If this is running on a power BI Premium App Workspace I would use the Premium Capacity App and see what is happening at that time with regards to your resources.
I would also suggest looking at the dataset, making sure it is using the Star Schema, then having optimal DAX measures written. And then finally look at the visual that is being used to see if that too is consuming a lot of resources?
You can use DAX Studio to open the PBIX and see how much memory the dataset is consuming when opened: https://www.sqlbi.com/tools/vertipaq-analyzer/
If this is running on a power BI Premium App Workspace I would use the Premium Capacity App and see what is happening at that time with regards to your resources.
I would also suggest looking at the dataset, making sure it is using the Star Schema, then having optimal DAX measures written. And then finally look at the visual that is being used to see if that too is consuming a lot of resources?
You can use DAX Studio to open the PBIX and see how much memory the dataset is consuming when opened: https://www.sqlbi.com/tools/vertipaq-analyzer/