Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm receiving the following error on a table while rendering. And by the way, the data cannot be filtered any more than it already is.
Please advise.
Resources Exceeded
This visual has exceeded the available resources. Try filtering to decrease the amount of data displayed.
Please try again later or contact support. If you contact support, please provide these details.
More details: Resource Governing: The query exceeded the maximum memory allowed for queries executed in the current workload group (Requested 1048579KB, Limit 1048576KB).
Activity ID: 01c809d1-87a4-4432-9396-deac2b18172e
Correlation ID: ede6685c-4852-2b1f-0e4b-86ad607bcfe9
Request ID: 74ede226-5486-7d21-0e69-0574f579efd3
Time: Tue Mar 12 2019 14:28:27 GMT-0400 (Eastern Daylight Time)
Version: 13.0.8730.152
Cluster URI: https://wabi-us-east2-redirect.analysis.windows.net
Hi @dharland ,
It seems that you have problems in Power BI Service.
When do you get this issue?
In addition, do you get this issue in Power BI Desktop?
Best Regards,
Cherry
Hi.
Same problem. I created a page with two measures used in about 50 objects (raibowGauge, tabs, databar kpi ) with different filters by object.
Measures are calculated on a table that contains about 70K records (originally, 1M records).
In PowerBI dashboard, no problem. PBI Service returns a "Resource Exceeded" error when I use a filter.
Up to a week ago, 1M records were evaluated with an acceptable delay. I needed to reduce to 70K deleting some columns because time delay increased dramatically (online).
Then I added code below in the measure to filter recordset using values selected by user in another table that cannot be linked. In other words, for this this table I need to evaluate a result by record.
If user uses page filters: no problems (It means: __SelectedUserInOrg_Filters] = "^^")
__Xtra G-Measure =
VAR xVal_Actual_LOC_Year = CALCULATE( sum(Source_Xtra_Budget_Final_Summary[#Xtra Actual Value (kLOC)])
;FILTER( ALLEXCEPT( Source_Xtra_Budget_Final_Summary
;Source_Xtra_Budget_Final_Summary[Period Type]
;Source_Xtra_Budget_Final_Summary[! PG Group]
;Source_Xtra_Budget_Final_Summary[! Segment Group]
)
;or( [__SelectedUserInOrg_Filters] = "^^"
;and( and( or( iserror(search("^SEGM." ;[__SelectedUserInOrg_Filters] )) //No SEGM filter
;not(iserror(search("." & [Segment Code] & "." ;[__SelectedUserInOrg_Filters] ))) //otherw SEGM found in string
)
;or( iserror(search("^COU." ;[__SelectedUserInOrg_Filters] )) //No SEGM filter
;not(iserror(search("." & [Demand Country] & "." ;[__SelectedUserInOrg_Filters] ))) //otherw SEGM found in string
)
)
;and( or( iserror(search("^PRV." ;[__SelectedUserInOrg_Filters] )) //No SEGM filter
;not(iserror(search("." & [Demand Province] & "." ;[__SelectedUserInOrg_Filters] ))) //otherw SEGM found in string
)
;or( iserror(search("^PG." ;[__SelectedUserInOrg_Filters] )) //No SEGM filter
;not(iserror(search("." & [Product PG] & "." ;[__SelectedUserInOrg_Filters] ))) //otherw SEGM found in string
)
)
)
)
))
RETURN
.....
I have the same issue here except that my users see no such issue on the table visual from their end while i'm getting the visual showing the error using my login which is admin user.
I don't understand how me and users are seeing different result on the same report.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.