How to detect object / row level security and show a different visual

[YukiK]

For the visual where object / row level security is in effect, it won't get populated and just show an error on the visual.

But is there anyway to show a better message? I'd like to do something like when a person doesn't have access to the data in a visual, instead of showing the visual, show a text box saying something like "You don't have access to see this visual".

Thanks in advance.

[Anonymous]

Hi @YukiK,

In fact, the RLS filter worked the same as a common filter. You can create a card visual with custom expression to use to show some notice message if the original visual records have been filtered to blank.

Display Custom Message in the Visual Until a Selec... - Microsoft Power BI Community
Regards,

Xiaoxin Sheng

[YukiK]

How about handling OLS? It's basically where the tables / columns are gone, which I'm not sure how to catch in DAX...

[Anonymous]

Hi @YukiK,

AFAIK, OLS will affect the table structure. So I think you need to do some operations on the query table side use a template to formatting the table structure.
For example:

Initiation table with a static structure with all fields similar to your database. Fill up the filtered field with blank values, you can write RLS expressions to check multiple fields to trace if some fields not existed value(it means these fields have been filtered by OLS). Then you can use if statement with particular processing with these situations.
Regards,

Xiaoxin Sheng

[YukiK]

I'm not sure if I'm confident to implement that. It looks like there is not an out-of-box solution to this.