Forum Discussion
Help with Query has exceeded available sources error
I am trying to run the following measure in a visual and I am getting the Query has exceeded the available resources message.
Here is the measure:
Hi, BaldAccountant
Thanks for AnkitaaMishra's reply. The issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.As suggested in the error, you may need to try filtering the visual to reduce the amount of data in the result currently. there is limit. Apply data-point limits and strategies by visual type
And you can follow the tips to optimize your report：
1.Do not expose in a view a column that is not necessary in the Power BI data model.
2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.
3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. )
This is the related document, you can view this content:
The “Visual Has Exceeded The Available Resources” Error In Power BI
Visual has exceeded the available resources - Table Visual
Error: Resource Governing - Microsoft Power BI Community
resources exceeded - Microsoft Power BI Community
only Premium capacity can increase the per-query memory limit, you can refer to these articles if you need: What is Power BI Premium? How to purchase Power BI Premium
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
4 Replies
Hi, BaldAccountant
Thanks for AnkitaaMishra's reply. The issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.As suggested in the error, you may need to try filtering the visual to reduce the amount of data in the result currently. there is limit. Apply data-point limits and strategies by visual type
And you can follow the tips to optimize your report：
1.Do not expose in a view a column that is not necessary in the Power BI data model.
2.Optimize the DAX calculation used in this visual to use less memory and return faster or change what the visual displays.
3.Remove unnecessary precision or split granularity values to reduce cardinality(Significantly reduce highly unique datetime values by splitting the date and time into separate columns. )
This is the related document, you can view this content:
The “Visual Has Exceeded The Available Resources” Error In Power BI
Visual has exceeded the available resources - Table Visual
Error: Resource Governing - Microsoft Power BI Community
resources exceeded - Microsoft Power BI Community
only Premium capacity can increase the per-query memory limit, you can refer to these articles if you need: What is Power BI Premium? How to purchase Power BI Premium
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi BaldAccountant ,
Try creating base measures and then use it in your SWITCH statement.
Example : Create a measure for :
_TotalYTD = TOTALYTD([Cases],Dates[Date])
Then modify the switch statement as :Current Units PVM =SWITCH(Selected[PVM Selected Current],"Current",[Cases],"Current YTD",_TotalYTD,"Prior YTD",CALCULATE(_TotalYTD,SAMEPERIODLASTYEAR(Dates[Date])),"YTD Avg",DIVIDE(_TotalYTD,MONTH(MAX(Dates[Date])),0),0)
OR try referring below links :
https://community.fabric.microsoft.com/t5/Desktop/Visual-has-exceeded-available-resources/td-p/1218512
https://community.fabric.microsoft.com/t5/Service/visual-has-exceeded-available-resources/m-p/560338
Thanks,AnkitaSorry but that did not change the outcome.
If it helps any, I use this measure in a half dozen other measures to get to a PVM analysis. If I put all of those measures in a table visual it gives me this error, and it runs fine for Current period and the YTD, but not for the YTD average. If I take some of the measures off, this calcuation and other remaining measures calculate just fine.
