Show text visual when user not in RLS

[Anonymous]

What I wish to do is display a text visual informing the user why it's not seeing data, and how it can be fixed. I only want to display this visual when the user is not part of a RLS role.

Is there any way I could perform some logic for checking if the current user viewing the report in the service, is part of any of my defined roles? I imagine that if it's possible It'd be possible with some DAX logic I'm not currently aware of.

In advance, thanks!

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

I'd like to suggest you write a measure to check table rows and return specific notice text when it has no records and create a card visual with this measure.

Measure =
IF (
    COUNTROWS ( ALLSELECTED ( Table ) ) = 0,
    "Tabel records has been filtered",
    "login: " & USERNAME ()
)

Regards,
Xiaoxin Sheng