Forum Discussion
10240 MB query memory limit - Premium Per User - Missing Capacity Settings in Admin Portal
Hey,
so unfortunately to get to the settings, you need to be a Power BI admin.
Second bad news, you cant configure query limit for Premium Per User even if you have access to the admin portal. See the snapshot below.
If you had Premium Capacity ( Organizational license), then you should be able to do it. If you do have premium capacity ( not Premium Per USER ), reach out to your Power BI admin.
If not, you may need to simplify your calculation.
Hope this helps.
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 ?
PPV =SUMX(VALUES('PPO Open Conf and Rec'[Yr and Item]),CALCULATE([MTD Weighted Price minus Weighted Avg STD MTD Price] * [Running Total Qty MTD],ALL('DimDate'[MMM-YRYR])))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?Hi,
Try to remove your Grand Total in your pivot table. We encounter the same issue. As now we did not find a real solution. Let me know if you find one. Thanks
