Forum Discussion

JohnLow's avatar
JohnLow
Icon for Helper I rankHelper I
5 years ago
Solved

Row Level Security Question

Hi,   I'm new to RLS and need a little help. I've 3 tables Users, Network and Sales. Users has a relationship to Network which in turn has a relationship to Sales. Users have 3 roles: Network User,...
Need Help
  • sayaliredij's avatar
    sayaliredij
    5 years ago

    Hi JohnLow 

     

    Could you try applying a security filter

     

    I tried at my end and it works

     

    For Finance user - everything is visible and for network user - only data related to him

     

     

JohnLow's avatar
JohnLow
Icon for Helper I rankHelper I
5 years ago

sayaliredij Thanks. I have a similar DAX statement for my network role in the pbix file above. This works ok. I'm just wondering do I need another role. Could you have a look at the pbix file attached please?

[NetworkID] IN
SELECTCOLUMNS (
    FILTER (
        Network,
        Network[UserId]
            = LOOKUPVALUE ( Users[UserID], Users[UserName], USERPRINCIPALNAME() )
    ),
    "NetworkID", [NetworkID]
)

 

JohnLow's avatar
JohnLow
Icon for Helper I rankHelper I
5 years ago

Ideally what I would like is one role. I would create a new column in the Users table with an override flag. 

OverRideFlag = IF(
	ISERROR(
		SEARCH("Network", Users[Role])
	),
	"Y",
	"N"
)

 The DAX would then say, if User is a network user(override flag = no) follow the DAX in message 4  above, if not (override flag = yes) access everything in the Sales table. I could then add the everyone group to the powerbi online service and then it would filter automatically? The only manual work I would have to do is to share the report. 

Would be great if you could help me with the DAX, thanks again.