Forum Discussion

Ashe_-123's avatar
Ashe_-123
Frequent Visitor
2 years ago

This visual has exceeded the availiable resource

This visual has exceeded the availiable resource. try filtering to decrease the amont ofdata display on power bi Matrix vissual.

Please advise way to display millions of rows or any selection to minimize display size

1 Reply

  • Hi Ashe_-123 , This error means, the query taking loger than 225 secs or is taking too much memory. Inefficient dax calculation, Filtering whole table than a specific column can cause this problem too. You are bringing a huge amount of data into the visualization. The solution for this issue is to reduce the unnecessary amount of data you are bringing into the visualization. You can reduce the size of underlying table by grouping method if possible, or can filter a specific column of the table. 

     

     

    Hope this Helps!!
    If this solved your problem, please accept it as a soltuion!!

     

    Best Regards,
    Shahariar Hafiz