Forum Discussion
Control Row Level Security Using Excel spreadsheet
Hello,
I created a excel which will control the RLS with Person name, Email and GEO and Product. That table is called as User_Access in the diagram. Now when i import the model I created a relationship between User_Access and Geo_Hierarchy tables connecting Geo.
Next step i went to manage roles and created a role called accessa and declared [User] = USERPRINCIPALNAME().
Next i published the same to Service and shared the report with a user. When user viewed the report he is getting below error
Can someone tell me where I am going wrong. I checked many forums but nothing helped. If someone can shed some light on where I am going wrong will be helpful.
Note: I did not go to dataset for the report and make any changes. Not sure if that is a step I am missing.
Has anyone found a way of linking the excel to the dataset access step? Surely there is a way that the excel list can automatically add the users to dataset security?
Hi Karthik,
Did you check the bidirectional is active in the relationship level ?