Forum Discussion

dharland's avatar
dharland
Advocate IV
7 years ago

Resources Exceeded

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...
Need Help
AndreVar67's avatar
AndreVar67
Frequent Visitor
7 years ago

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] = "^^")

 

If user selects a record in the table mentioned above, the page returns  "Resource Exceeded" error
(It means e.g.: __SelectedUserInOrg_Filters] = "^SEGM^IND.TRA.^PRV.EAST.")
 
 

__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
.....

 

 

daniellupwt's avatar
daniellupwt
Regular Visitor
7 years ago

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.