Forum Discussion
Visual has exceeded available resources error
I have created a live model/report to show inventory differences between 2 systems. In the table/visual I have product, description, a few other columns and then both system's quantity, and then a co...
Hi globster19
My assumption is going to be because in order to filter it has to check the entire table for <> 0 and this means it has to put the entire table in memory.
What if instead on the column where you have QTY, you create another column in Power Query which says 'if [QTY] <> 0 then "Zero", Else "Many" '
Then in your table put in the above column and put the filter as "Many"?
Thank you for the response GilbertQ ,
However since my report is live connected to the model, I cannot use power query via transform data. Any other ideas of how I can get around that?