Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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.
Hi @Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
Hello Dale,
Could you please let me know if am clear
Hi @Anonymous,
You are quite clear. Livio provided the solution. Did it work?
Best Regards,
Dale
Hello All,
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:O 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.
REgards,
Varun
Hi @Anonymous,
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.
Best Regards,
Dale
Looks like you need Row LEvel Security:
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |