Reply
Regular Visitor
Posts: 27
Registered: ‎09-17-2018

share dashboard

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.  

Super User
Posts: 751
Registered: ‎09-16-2018

Re: share dashboard

Looks like you need Row LEvel Security:

 

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

 

 



Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut!

Community Support Team
Posts: 7,619
Registered: ‎05-02-2017

Re: share dashboard

Hi @chandra_0202,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor
Posts: 27
Registered: ‎09-17-2018

Re: share dashboard

Hello Dale,

 

Could you please let me know if am clear

Community Support Team
Posts: 7,619
Registered: ‎05-02-2017

Re: share dashboard

Hi @chandra_0202,

 

You are quite clear. Livio provided the solution. Did it work? 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor
Posts: 27
Registered: ‎09-17-2018

Re: share dashboard

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 MSmiley Surprised 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 

Community Support Team
Posts: 7,619
Registered: ‎05-02-2017

Re: share dashboard

Hi @chandra_0202,

 

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.

share-dashboard

 

 

Best Regards,
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.