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.
Hello,
I have created/used row-level security (RLS) with Power BI Desktop to restrict data access for given users at the Power BI Service website. But, after that, how to enable some users, like super users, to see all rows?
For example, I define Role_1 for the Region_A info, Role_2 for the Region_B info. This works fine on the Power BI Service website: the Role_1 users only see Region_A info; the Role_2 users only see Region_B info.
But, if I want a super user X to view all regions info, how should I do?
If I do nothing about X's security, X told me that he could not see any info and got a pop-up alert showing that: "This visual contains restricted data."
How should I do?
Solved! Go to Solution.
Hey @powerbiasker ,
simply create a role e.g. SuperUser.
To be consistent I use the table that contains the region column and then I provide simply this:
The DAX statement is a simple TRUE.
Hopefully, this provides what you are looking for.
Regards,
Tom
Hi @powerbiasker ,
It can be divided into two situations:
IF (
MAXX ( FILTER ( 'Email', 'Email'[Email] = USERNAME () ), 'Email'[Is SuperUser] ) = 0,
'Email'[Email] = USERNAME (),
TRUE
)
Test result:
You can refer this article and I have created a sample file
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Amazing solution!
Thanks for sharing!!
Hi @powerbiasker ,
It can be divided into two situations:
IF (
MAXX ( FILTER ( 'Email', 'Email'[Email] = USERNAME () ), 'Email'[Is SuperUser] ) = 0,
'Email'[Email] = USERNAME (),
TRUE
)
Test result:
You can refer this article and I have created a sample file
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hey @powerbiasker ,
simply create a role e.g. SuperUser.
To be consistent I use the table that contains the region column and then I provide simply this:
The DAX statement is a simple TRUE.
Hopefully, this provides what you are looking for.
Regards,
Tom
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |