Forum Discussion

yogevz's avatar
yogevz
Helper II
9 years ago
Solved

Can't Get RLS to Work

Hi all help!!!!!!!!!! can't get the RLS to work. i tried even just 1 table with 3 rows and nothing. can somebody attach 1 small powerbi file with basic RLS which works? i will take this file and...
Need Help
yogevz's avatar
yogevz
Helper II
9 years ago

thanks.

i talked about RLS with username() permissions...

when u have table with users, which is connected to transaction table,

and when user enter - he sees only the record on his username.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi yogevz.

 

At desktop side, you should use "view as role" to enable the rls affect.

 

 

 

Regards,

Xiaoxin Shneg

  • yogevz's avatar
    yogevz
    Helper II
    9 years ago

    this is what i did - but it doesn't work...

    see picture 1 - data + i inserted the user as role to see data,

                             u can see also in the lower part the user i am using.

    see picture 2 - i get no data. and in the lower part - u can see again the user i used...

    what i am missing?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi yogevz,

       

      Can you share us a sample file to test?

       

      Below is my sample:

       

      Role table:

       

      Measures:

       

      USERNAME = USERNAME()

       

      Role = LOOKUPVALUE(Sheet2[User],Sheet2[Login],USERNAME()) // look up the role.

       

      RLS formula:

       

      if(
      ISERROR(SEARCH("SalesManager", [Role]))=FALSE(),
      [SalesManager]=[Role]
      ,
      [SalesMan]=[Role]
      )

       

      Regards,

      Xiaoxin Sheng

      • yogevz's avatar
        yogevz
        Helper II
        9 years ago

        attach sample file.

        in this file, only when i do as role (attach picture also), then i get 1 row (i am not sure this is what i need to do),

        but if this is what i need to do - it doesn't work in the server - when i enter in a different user i need to see

        0 rows, but i see all rows...

        attach url dropbox to the powerbi file...

         

        https://www.dropbox.com/s/nfup6y1p0x62yd5/test%20for%20RLS6.pbix?dl=0