I create a a dashboard with respect to the owners and i wish to share the Data to respective owners only. for example i have data belongs to two owners X & Y and wish to share data with the owners. I need to share data related to X only and Y owner should not view the data of X owner. Please help me this regards let me know if you need further details.
Appreciate your advise.
Looks like you need Row LEvel Security:
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Could you please mark the proper answers as solutions?
You are quite clear. Livio provided the solution. Did it work?
Thanx for the Link but need more clarity on this.
I have below tables
Subscription: Factsheet with columns (Dept, Owner,Amount )
MasterOwners: created this table which has Unique Owners List ( Owners, UserName)
Created M relationship between MasterOwners and Subscriptions with cross Filter direction as Both and apply security which is not allowing.. Please advise how and in which table the DAX filter to be applied.
It should be in MasterOwners table in this scenario. The RLS works along the relationships. Please also test the RLS rules before applying in the Production. Please refer to the snapshot below.