Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sam_gift
Helper I
Helper I

How to Handle Object Level Security without error

Hi,

 

I have implemented Row level and Object Level Security using this link.

Lets assume I have User Group A and User Group B. Group A can see all the columns where as Group B cannot see Column1 and Column2.

I have a table which have the few columns including Column 1 and Column 2.

Is there a way, when Group B accessing that table, can see the other data except Column1 and Column2 instead of showing the whole table as error

sam_gift_0-1719612312616.png

 

Thanks!

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

Try adding the columns via Field Parameters.

View solution in original post

v-yiruan-msft
Community Support
Community Support

Hi  @sam_gift ,

Base on your description and screenshot, it seems like the visual can't be displayed normally when apply both RLS and OLS. Could you please get and provide the details of error message by clicking "See details" in below screenshot? Thank you. Later we will check it and make troubleshooting.vyiruanmsft_0-1719801587513.png

In addition, you can refer the following links to make troubleshooting and try to get the solution.

1. Check if hit any limitation

Considerations and limitationsvyiruanmsft_1-1719801770837.png

2. Mastering OLS in PowerBi: Fixing Broken Visuals 

How to fix broken visuals

There might different couple of workaround to fix lets discuss one of the best one i.e. using Field parameter in visual instead of using direct measure.

Scenario 1: Suppose you have two measures Discount and Sales. Under OLS particular group of people are not allowed to see sales. If we use OLS and put both measures individually it will break complete visual, it should show only Discount.

 

To overcome this scenario make a field parameter of both Discount and Sales. Use parameter in visual instead of individual measure. Discount and Sales should be measures.

vyiruanmsft_2-1719801806871.png

 

Scenario 2: If you need to restrict a particular column in a visual (direct column or calculated column), using Field Parameters may not be sufficient.

This scenario depends on use case such as if you can use measure instead of using Column/Calculated Column using Min, Max , etc of value and follow same path as scenario 1.

Best Regards

Community Support Team _ Rena
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

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi  @sam_gift ,

Base on your description and screenshot, it seems like the visual can't be displayed normally when apply both RLS and OLS. Could you please get and provide the details of error message by clicking "See details" in below screenshot? Thank you. Later we will check it and make troubleshooting.vyiruanmsft_0-1719801587513.png

In addition, you can refer the following links to make troubleshooting and try to get the solution.

1. Check if hit any limitation

Considerations and limitationsvyiruanmsft_1-1719801770837.png

2. Mastering OLS in PowerBi: Fixing Broken Visuals 

How to fix broken visuals

There might different couple of workaround to fix lets discuss one of the best one i.e. using Field parameter in visual instead of using direct measure.

Scenario 1: Suppose you have two measures Discount and Sales. Under OLS particular group of people are not allowed to see sales. If we use OLS and put both measures individually it will break complete visual, it should show only Discount.

 

To overcome this scenario make a field parameter of both Discount and Sales. Use parameter in visual instead of individual measure. Discount and Sales should be measures.

vyiruanmsft_2-1719801806871.png

 

Scenario 2: If you need to restrict a particular column in a visual (direct column or calculated column), using Field Parameters may not be sufficient.

This scenario depends on use case such as if you can use measure instead of using Column/Calculated Column using Min, Max , etc of value and follow same path as scenario 1.

Best Regards

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

Try adding the columns via Field Parameters.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.