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
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

       

      • yogevz's avatar
        yogevz
        Helper II
        9 years ago

        Hi

        i succeed doing the RLS.

        now - new issue.

        from one side - users and department

        from second side - fact table, every department has several of rows (table has history).

        now - i can't create join between the tables!

        powerbi doesn't permit join between 2 tables with many values (many to many).

        what now??