Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

PowerBI RLS

Hi All,

 

I am new to PowerBI

I have an table with data like [email protected],[email protected],[email protected] in EmailAddress column.

I have created a Role in  RLS using Username() function like [EmailAddress]=Username().

But while testing the Role in PowerBI Desktop by passing one emailaddress I am not getting the result as expected.

If I pass all the 3 EmailAddress then it is working fine.

Please kindly help me on this is there any function so I can handle this comma seperated data instead of split.

Need Help

11 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I wanted DAX to find the EmailAddress of the logged in user from the comma seperated data.

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        8 years ago

        Right, I think the tricky part will be getting this to work with RLS but I would think that something like this would work:

         

        SEARCH(USERNAME(),[EmailAddress],0,-1)>0
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi All,

    I am new to PowerBI

    I have an table with data like [email protected],[email protected] in single cell,I have used Username() function in RLS like [Email]=username().

    While Testing the Role in PowerBI Desktop I have passed one of the Email Address like [email protected] I am not getting the expected output . PowerBI is expecting me to pass both the Email address.

    kindly please help me on this issue how to get data from comma seperated data is there any  function to do that.