Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 using that is connected to power BI through Analyze in Excel in Power BI Services. As you can see below, there are no settings in my Admin Portal under Capacity Settings - there is nothing to adjust. Can someone help please? I need to be able to use the Analyze in Excel reporting from Power BI Services and need to resolve this error that happens upon refresh as I cannot remove or add of any data fields.
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 ?
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
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?
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
35 | |
32 | |
19 | |
12 | |
8 |
User | Count |
---|---|
52 | |
37 | |
29 | |
14 | |
12 |