Forum Discussion

Poojajunnu's avatar
Poojajunnu
Frequent Visitor
9 months ago
Solved

custom message row level security in power bi.. How to implement it in power bi

custom message row level security in power bi.. How to implement it in power bi

Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    9 months ago

    Hi Poojajunnu,

     

    You can achieve this by following below steps:

    Firstly check if the use has access to the report by checking user principle name with your table which has their email ids.

     

    HasDataAccess =
    IF(
    ISFILTERED(SecurityUserMapping[UserEmail])
    && MAX(SecurityUserMapping[UserEmail]) = USERPRINCIPALNAME(),
    1,
    0
    )

     

    Now create a measure AccessMessage =
    IF (
    [HasDataAccess] = 0,
    "⚠ You are not authorized to view this data.",
    BLANK()
    )

    Now add this measure to a card visual and place on top of all visuals

     

    and then turn off other visuals by adding HasDataAccess in filter pane by selecting 1 to show and 0 to hide.

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

  • rohit1991's avatar
    rohit1991
    9 months ago

    Hii Poojajunnu 

    Power BI does not allow custom pop-ups or messages directly through RLS. When RLS blocks all rows, visuals simply show blank. The only workaround is to create a DAX measure that checks when the user has no data and display a card with a custom message (e.g., “You do not have access to this data”). This is the only supported method to show a custom message with RLS.

    RLS_Message =
IF(
ISFILTERED(YourTable[UserID])
&& COUNTROWS(YourTable) = 0,
"You do not have access to this data.",
BLANK()
)

6 Replies

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    9 months ago

    Hi Poojajunnu,

     

    You can achieve this by following below steps:

    Firstly check if the use has access to the report by checking user principle name with your table which has their email ids.

     

    HasDataAccess =
    IF(
    ISFILTERED(SecurityUserMapping[UserEmail])
    && MAX(SecurityUserMapping[UserEmail]) = USERPRINCIPALNAME(),
    1,
    0
    )

     

    Now create a measure AccessMessage =
    IF (
    [HasDataAccess] = 0,
    "⚠ You are not authorized to view this data.",
    BLANK()
    )

    Now add this measure to a card visual and place on top of all visuals

     

    and then turn off other visuals by adding HasDataAccess in filter pane by selecting 1 to show and 0 to hide.

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

  • rohit1991's avatar
    rohit1991
    Super User
    9 months ago

    Hii Poojajunnu 

    Power BI does not allow custom pop-ups or messages directly through RLS. When RLS blocks all rows, visuals simply show blank. The only workaround is to create a DAX measure that checks when the user has no data and display a card with a custom message (e.g., “You do not have access to this data”). This is the only supported method to show a custom message with RLS.

    RLS_Message =
IF(
ISFILTERED(YourTable[UserID])
&& COUNTROWS(YourTable) = 0,
"You do not have access to this data.",
BLANK()
)
  • Zanqueta's avatar
    Zanqueta
    Super User
    9 months ago

    Hi Poojajunnu,


    I’d like to contribute, so let me show you how I usually do it in my reports:

    I combine these into a single field:

    Labels - UserLogin =
var us = USERPRINCIPALNAME() 
var n = RANDBETWEEN(1,25)
var icon = SWITCH(TRUE(),
n= 1, "🛸", n= 2, "🚀", n= 3, "🌌", n= 4, "🌠", n= 5, "👀", n= 6, "😉", n= 7, "😊", n= 8, "👽",
n= 9, "🔔", n= 10,"☢️", n= 11,"✔️", n= 12,"©️", n= 13,"🎈", n= 14,"🔮", n= 15,"💡", n= 16,"🙃",
n= 17,"😎", n= 18,"🤓", n= 19,"🧐", n= 20,"👻", n= 21,"👾", n= 22,"🤖","🌍")
return
" Hello " & [NomeUsuarioLogado] &"! "& icon

     

    This measure retrieves a name from another table when I have both the user’s name and email.

     

    NomeUsuarioLogado = 
var us = USERPRINCIPALNAME()
return
LOOKUPVALUE(dim_UserActiveDirectory[givenName],dim_UserActiveDirectory[mailuser],us,BLANK())


    Of course, the use of icons may not be applicable. 😎

    If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

    Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

     

  • v-echaithra's avatar
    v-echaithra
    Community Support
    8 months ago

    Hi Poojajunnu ,

    May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

    Thank you.