Visual has exceeded the available resources - Table Visual

[rocko95]

Hello,

I'm using regular table visual and it does not work. The thing is that I have large data, but still can not find solution to help this visual work. The visual should show more than 20k rows, but as i know this visual does not have the limit. When I filter the data then the visual works.

Unfortunately my data is private and I cannot share with you. 

I have simple questions. To solve this problem what kind of optimization do you suggest?

1. doublecheck the relationships.

2. reduce the amount of data.

3. check dax measure formulas.

Thank you in advance.

[Anonymous · Accepted solution]

Don't @rocko95,

It is suggested to adjust the DAX calculations used in this visual (I suggest you read the section on materialization from p568of "The Ultimate DAX Guide" or this previous article covering the same terrain) to use less memory and return faster or change what the visual displays.

There's an article you might refer to:

The "Visual has exceeded available resources" error in Power BI

Best regards

Stephen Tao

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[Syndicate_Admin]

Hello,

Thanks for your reply! I have tried somehow to optimize DAX measures and it helped.

I have had about 12 measures on this visual and tried to write the measures individualy. Before that I was doing something like this -

General Measure - Formula

Measure 1 - Calculate("General Measure", Filter("Product A"))

Measure 2 - Calculate("General Measure",Filter("Product B"))

now I have individual measures for products -

Measure 1 - Calculate(Formula,Filter("Product" A"))

Measure 2 - Calculate(Formula,Filter("Product" B"))

Sorry if I could not explain well.

Regards!

[Tahreem24]

@rocko95 ,

Every visual has some limitations of data that it can handle. If data is exceeded that limit so it won't show any data on that visual. So, I recommend you to supress or shrink your data as I dont know your measure logic but if you can optimize your measure which will help you to show data on that visual so please do so.