cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amit_gupta
Frequent Visitor

Role Level Access in PowerBI

Hey everyone,

 

Can anyone help me with the below questions:

  1.  Is anyone aware of any feature on PowerBI which gives us the advantage with “role level access” to the viewers? I am aware of the feature with the button “Manage roles”, was curious to explore if there is more to it!?
    Eg: If I have 10 pages in my report, is there a way by which I can restrict the access to certain pages to certain viewers?
  2. Can we also give "category level access" to the viewers?
    Eg: If I have the KPIs for two accounts i.e. Amazon and Flipkart (using accounts as a filter) - How can we restrict the access to the Flipkart Datapoints when viewed by the Amazon guy.

    To simplify it: Let's say I have two users X & Y. X caters to Amazon and Y caters to Flipkart.
    How can I give access to X so that he is only able to see data points specific to his account i.e. Amazon?

Amit

2 ACCEPTED SOLUTIONS
v-alq-msft
Community Support
Community Support

Hi, @amit_gupta 

 

Answer1:

It is unsupported to use RLS to restrict the access to certain pages to centain viewers. Filters restrict data access at the row level, and you can define filters within roles.

 

Answer2:

You can take advantage of the DAX functions username() or userprincipalname() within your dataset to filter the result for the corresponding user.

 

Best Regards

Allan

 

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

View solution in original post

amit_gupta
Frequent Visitor

Resolved - expecting we don't have any ways to give page-level access!

View solution in original post

4 REPLIES 4
amit_gupta
Frequent Visitor

Resolved - expecting we don't have any ways to give page-level access!

View solution in original post

MariaP
Solution Supplier
Solution Supplier

v-alq-msft
Community Support
Community Support

Hi, @amit_gupta 

 

Answer1:

It is unsupported to use RLS to restrict the access to certain pages to centain viewers. Filters restrict data access at the row level, and you can define filters within roles.

 

Answer2:

You can take advantage of the DAX functions username() or userprincipalname() within your dataset to filter the result for the corresponding user.

 

Best Regards

Allan

 

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

View solution in original post

PC2790
Solution Sage
Solution Sage

Hello,

 

You can take advantage of Row Level Security in Power BI to restrict the data according to the roles that you define and map the users according to those roles.

Refe here on how to do it.

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors