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.
Hi,
I'm having an issue to get my RLS function to work when for a specific use i get two true values.
Power BI apparentely bugs and keeps trying to load for 10-15min then it says viasuals exeeded limits.
RLS Function: Country = User_Country
User_Country = LOOKUPVALUE('User'[Country];'User'[Name];[UserName])
Eg.: For Bob, i wan't to filer a list to show only the countries he should see. For John and JAck RLS works perfectly.
'User' List
Name | Country
Bob | US
Bob | France
John | China
Jack | UK
Does anyones knows how to solve this?
I've tried to change the acesss list ot looik like this, yet it did not work:
Name | Country
Bob | US || France
Bob | US ; France
Thanks for your help!
I'm not sure if I understand your scenario correctly. Based on your description, if you have two tables with 1:* relationship as below.
You can try to define the RLS function like:
[Country] = CONCATENATEX( FILTER( User, User[Name] = [UserName] ), User[Country], " ; " )
Best Regards,
Herbert
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.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |