cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kasunpathirana Regular Visitor
Regular Visitor

Possibility of Using Roles to not to display some columns in report

For an example there is an item with quantity and price and total amount.

 

Is it possible in Power BI to create two different roles to show the total amount to the user group1 and for the user group2 will not see the total amount only see other fields in the table or other visualizations not to show this total amount field values.

 

Is there a workaround to do this rather than using two reports to cater for this requirement.

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: Possibility of Using Roles to not to display some columns in report

Hi @Kasunpathirana,

 

Currently, there is no any option for configuring column level security in Power BI. Here is a similar idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature.

 

In addition, as @jordi-f has mentioned above, using Unpivot option to unpivot the group1 and group2 column first, then applying the row level security may be a possible solution in your scenario. Smiley Happy

 

Regards

View solution in original post

3 REPLIES 3
jordi-f
Advisor

Re: Possibility of Using Roles to not to display some columns in report

This is not possible in Power BI because Row level security is not applicable to columns.  As far as I know only unpivotting the columns and adding Row level security will prevent users to see these values.

 

I just saw an announcement of new tabular model features and this was in. check: https://www.youtube.com/watch?v=vNtpW7aaM-s&lipi=urn%3Ali%3Apage%3Ad_flagship3_profile_view_base_rec...

@ 03:20

v-ljerr-msft Super Contributor
Super Contributor

Re: Possibility of Using Roles to not to display some columns in report

Hi @Kasunpathirana,

 

Currently, there is no any option for configuring column level security in Power BI. Here is a similar idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature.

 

In addition, as @jordi-f has mentioned above, using Unpivot option to unpivot the group1 and group2 column first, then applying the row level security may be a possible solution in your scenario. Smiley Happy

 

Regards

View solution in original post

Kasunpathirana Regular Visitor
Regular Visitor

Re: Possibility of Using Roles to not to display some columns in report

Thanks for the reply Smiley Happy

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 196 members 2,614 guests
Please welcome our newest community members: