Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
We have a single table that we're using currently to set the RLS / DAX statement against. It is working great.
Email = UserPrincipalName() , very straightforward.
Use case now is allowing multiple users to see the same data. I've read through many of the existing workarounds for this. Is there a way to use Contains or another command that would leave our current schema in tact? Ideally would like to have multiple user names in the same field separated by comma or other delimiter.
Thanks for any insight.
Assuming that your data is similar to below.
Store | |
Store1 | john@abc.com;tom@abc.com |
Store2 | mat@abc.com |
Store3 | neel@abc.com |
Store4 | richard@abc.com;jack@abc.com |
Then you could try below DAX in the RLS window.
VAR __email = USERPRINCIPALNAME()
VAR __condition =
IF ( CONTAINSSTRING ( 'Table'[Email], __email ), TRUE (), FALSE () )
RETURN
__condition
Your single table is the right approach. But it doesn't mean each of your users has to appear only once in it. 😀
Not very clear on the need. See RLS groups can help
https://www.youtube.com/watch?v=oxYQ2GGefrs
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
31 | |
16 | |
14 | |
14 | |
9 |