Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Applying Row level Security to report

I have two tables and has relationship shown below How can I apply RLS so at to filter through UserEmail or user when user log in and by seeing only the VendorName reports? I have tried to cr...
Need Help
Tips and Tricks
  • jdbuchanan71's avatar
    jdbuchanan71
    4 years ago

    Anonymous 

    Your filter on the ItemTable would be something like this.

     

     

    ItemTable[VendorName] =
	LOOKUPVALUE (
		Vendor[VendorName],
		Vendor[VendorName], ItemTable[VendorName],
		Vendor[UserName], USERNAME()
	)

     

     

    I have attached a sample file for you to look at.  You can see the tables are not joined and you can test the role using 

    Modeling > View As

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

Anonymous 

Your filter on the ItemTable would be something like this.

 

 

ItemTable[VendorName] =
	LOOKUPVALUE (
		Vendor[VendorName],
		Vendor[VendorName], ItemTable[VendorName],
		Vendor[UserName], USERNAME()
	)

 

 

I have attached a sample file for you to look at.  You can see the tables are not joined and you can test the role using 

Modeling > View As