Forum Discussion
10240 MB query memory limit - Premium Per User - Missing Capacity Settings in Admin Portal
Hi, How do I get past the 10240 MB query memory limit ? I have a small data set and need help resolving this error in Power BI Desktop - Premium Per User account. I have an excel file that I'm u...
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])))
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