Forum Discussion

cruncher's avatar
cruncher
Helper II
1 year ago

How to Replicate ccomplicated Dynamic Row Level Security from Tableau to Power BI

We are currently using Tableau and exploring things to switch to Power BI. The major problem we are facing to replicate the row level security model from Tableau to Power BI.   We have a sales tran...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from _AAndrade , please allow me to provide another insight: 
Hi  cruncher ,

 

Here are the steps you can follow：

1. Create calculated columns in both tables to combine [Region], [Vertical], [Business Unit].

Table1_Con =
[Region]&"-"&[Vertical]&"-"&[Business Unit]
Table2_Con =
[Region]&"-"&[Vertical]&"-"&[Business Unit]

2. Modeling – Manage Roles – Filter data -- Place the following formula .

When applying to multiple users, you can replace " bicar " with USERPRINCIPALNAME().

var _name="bicar"
var _user1=
SELECTCOLUMNS(
    FILTER(ALL('Table2'),
    CONTAINSSTRING('Table2'[USERS LIST 1],_name)=TRUE()),"user1",[Table2_Con])
var _user2=
SELECTCOLUMNS(
    FILTER(ALL('Table2'),
    CONTAINSSTRING('Table2'[USERS LIST 2],_name)=TRUE()),"user2",[Table2_Con])
var _user26=
SELECTCOLUMNS(
    FILTER(ALL('Table2'),
    CONTAINSSTRING('Table2'[USERS LIST 26],_name)=TRUE()),"user3",[Table2_Con])
RETURN
IF(
    'Table1'[Table1_Con] in _user1 ||
    'Table1'[Table1_Con] in _user2 ||
    'Table1'[Table1_Con] in _user26,
    TRUE(),FALSE())

3. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly