Forum Discussion
Helper IIIError - 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
Helper IIIAn update. I used aggregated tables in sql and managed to reduce the number of rows from 5M plus rows to about 20 thousand rows. I have used direct query for the aggregated table and import query for the dimension tables
The dimension table are categories are single column table that has been imported using the following SQL query
Select Column_name From Table
However, when I add the attribute from the dimension table to the table visual or graph visual it takes a very long time for the report to refresh. The refresh seems to be a lot quicker when I used the corresponding dimension attributes from the fact table instead
I had a look at this blog by Chris Webb
https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/
For some reason I can't expand on the details of the problem. I don't have "show details" in the dialog box