Forum Discussion
Error - visual as exceeded the available resource
I managed to fix it I think. I changed the storage mode for my aggregated tables from direct to import. The dimensions are in import mode as well. Once I made the changes the interactions between the various visual elements are really quick
However, the granularity of the table rolled up to a high level. Going down further might cause the same issues again. I will test this further but for now it appears to be working
Hi Uniqueusername
Please create a summarize table with Aggregate level. use the summary table for visual
https://medium.com/power-platform/dax-power-bi-summarize-creating-a-single-column-summary-table-84e9c460d1b6#:~:text=Let's%20go%20to%20the%20Modeling,we%20specify%20the%20Orders%20table.
If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS
Thanks
Pijush
thank you, but how I go about bringing in date fields for the visuals. The date fields I am trying to pull in are from the date table
The problem doesn't seem to occur when I use the date attributes directly from the fact table in my model