How to Handle Object Level Security without error

[sam_gift]

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

Thanks!

[lbendlin · Accepted solution]

Try adding the columns via Field Parameters.

[v-yiruan-msft · Accepted solution]

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.

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 limitations

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.

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

[lbendlin · Accepted solution]

Try adding the columns via Field Parameters.