Forum Discussion

mvbonne's avatar
mvbonne
New Member
2 years ago
Solved

Visual has exceeded the available resources

Hi, I have been working on a dataset, and now it is getting quite large, which is causing the simple measure I used to have to crash. I receive a message in my application indicating tha...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi mvbonne ,

    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

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.