Adding multiple dax measures in table visuals creating trouble

[singhal14]

Hello Everyone,

We want to test a scenario where in on Table Visual we have to show lots of Dax Measures (10 -15), they are conditional measures which are very necessary to show in Single Table Visual but everytime it gets very slow, and I got the error saying 'Visual has exceeded available resources'.

I want to find any alternatives for this, Please let me know any workaround for it.

Thanks,
Akash

[v-ljerr-msft]

Hi @singhal14,

Are you getting this error when running from PBI Desktop or in PBI Service?

Desktop does not have the memory limit for the memory consumed by a model and it’s calculations(so you can try increasing the local memory in this scenario if you're using Desktop).

However Service has the memory limit, and there is no way to increase this limit. You may need to locate the corresponding calculation and change it. Or you can try putting some calculations onto the datasource side if possible, then use it whin Power BI. 

Regards