I started getting the error "This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed." The error itself is clear and obvious. But the problem is that ...
v-qiuyu-msft
Community Support
Community SupportHi Domantas,
The issue has been reported before internally: CRI 31505741.
The error message indicates that the query is fetching more data than allowed by the PBI Service (which has stricter limits than PBI Desktop). Please follow up with the customer to determine how to reduce the amount of data returned -- either by splitting the query into multiple queries or filtering the query. Note that filtering needs to be done in the query source text, not in the report, to reduce the amount of data returned from the source.
Best Regards,
Qiuyun Yu