- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Visual has exceeded the available resources
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
The "Visual has exceeded the available resources" error message is not the same as the max size of the dataset. Here is additional information:
https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @djurecicK2,
Thanks for your reply and detail information.
Do you have any idea about why I can run the report well as a member/contributor/admin of workspace, but got error as a WW org market user?
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-01-2024 09:39 AM | |||
05-02-2024 12:01 AM | |||
12-12-2021 07:28 AM | |||
05-08-2024 11:31 AM | |||
03-05-2024 10:20 AM |
User | Count |
---|---|
47 | |
38 | |
23 | |
19 | |
16 |