Visual Has Exceeded the resources error

[Vishwa972]

Hello everyone,

while using the following measure for a line chart 

adjustment(value in CHF) = ([+ve adjusments(value in CHF)] + ([-ve adjusments(value in CHF)])) + 0 ( Adding 0 to create a line on zero values )

getting the error as visual exceeded resouces when we drill through on data. if anyone knows what to do here kindly reply.

Thank you.

[Anonymous · Accepted solution]

Hi @Vishwa972 ,

There are some possible ways to fix this error, such as:

Check the query performance of your data source and optimize it if possible.
Use indexing to improve the query performance and reduce the memory consumption.
Consider using an SSAS solution instead of tapping on schema tables directly.
Reduce the number of fields or filters in your visual to decrease the amount of data displayed.
Enable the “Aggregate in storage” option for your visual if you are using DirectQuery or composite models.

Solved: Visual exceeded available resources error in Power... - Microsoft Fabric Community

Solved: Service: Visual has exceeded available resources. ... - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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