Forum Discussion
10240 MB query memory limit - Premium Per User - Missing Capacity Settings in Admin Portal
Hi, Last week I was able to add many measure fields to a pivot table from Exel Analyze option form Power BI Services, and this week I have not be able to do any reports or update existing because of repeated query limit errors. As you can see below, this pivot table is fairly small and im only trying to get a calculated measure to display 12 months worth of variance data.
Could this formlua be written more functionally ?
It is not the size of the pivot table that is the issue, its the calculation that is querying alot of rows. The calculation is iterating through a distinct list of [Yr and item], and for every iteration it requires 2 measures to be calculated, and the ALL functions returns a table for every iteration. If this has worked before, but it doesnt now, my guess is something may have changed in the back end of the data.
i see that you have a year slicer in cell B1, try loading the pivot table with only 1 year selected. Does it work?