How to Handle Object Level Security without error

Try adding the columns via Field Parameters.

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