Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

RLS string transformation

Hi All,   I am using Embeded power BI and in that RLS we are using. In the username() i am getting a string and i need to filter the data. In the RLS i get the list of values in the form of a strin...
  • tamerj1's avatar
    3 years ago

    Hi Anonymous 

    please try

    =
    SUBSTITUTE ( SUBSTITUTE ( USERNAME (), """", "" ), "'", """" )

  • Anonymous's avatar
    Anonymous
    3 years ago

    Thank you very much. All my single quotes are coverted into double quotes