Visual has exceeded the available resources

Anonymous · ‎03-01-2023

Hi team,

One of our report got 'visual has exceeded the available resources' issue after I added RLS, could you pls. kindly help to advise? thanks in advance.

We have Power BI Premium capacity for our organization, the capacity SKUs is P1/A4, we have max 6GB memory per query.

We added RLS rule in several datasets recently, users could see the data base on their role in table User List, WW org market users could see all of the data, users who have partial org markets access could see correspondingly org market data. This RLS works well in other datasets except one History dataset, History dataset includes many years' data, the dataset is 820MB, the total size of all datasets in our workspace is 2.5GB, we were assigned 10GB for our premium capacity workspace.

When I run this history report as a member/contributor/admin of our workspace, there is NO memory limit issue.
If I was removed from workspace and run the report as an user (with partial org markets role), there is NO memory limit issue.
But if I was removed from workspace and run the report as an user (with WW org markets role), then I got this memory limit issue.

RLS we added in dataset from desktop Modeling->Manage roles

We added a group which include all of our users (around 30 users) in dataset security part in service.

Var vUser = USERPRINCIPALNAME()
Var vMarkets = CALCULATETABLE(
VALUES('User List'[Org Market]),
FILTER(ALL('User List'),'User List'[Email] = vUser)
)
Var vCheck_WW = IF("WW" in vMarkets,TRUE(), [Email] = vUser)

Return
vCheck_WW