Forum Discussion

mapko's avatar
mapko
Helper I
9 years ago

Tabular model RLS in Power BI

All,   I am constantly failing in my attempts in trying to get RLS work in my PBI file that is based off a tabular model. In the tabular model I have define a role and when I analyze the data in XL...
Need Help
mapko's avatar
mapko
Helper I
9 years ago

Anonymous, quite frankly I was testing this wiht my own account. I limited the data to only one location, our of a dozen. I am an admin on the server but I am thinking that shouldn't really clash with RLS setting applied to my report. Yes, I am looking up users by the domain. Have only one. Even created a measure [USERNAME()] to verify correct username is parsed through the tool. All checks out.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

mapko See this post for a quick check.

In my experiance, as an admin of the tabular model Power BI will always show me everything. I have always needed to share the report with an end user that should be filtered in order to confirm that the RLS was working as expected in the reports.

  • mapko's avatar
    mapko
    Helper I
    9 years ago

    Anonymous, thanks. I asked my IT department to create a non-admin account for me for testing purposes. The solution to the issue in the post you shared did not do the trick. Fingers crossed non-admin account helps.

     

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi mapko,

     

    As you connect to SSAS tabular in live connection, it will apply the role which defined on SSAS side. But as you are server administrator, row filters do not apply. All data can be queried in this role. See: Roles.

     

    Best Regards,
    Qiuyun Yu

  • rkri000's avatar
    rkri000
    Frequent Visitor
    9 years ago

    Hi 

     

    anyone got any luck using rls in tabular models for powerbi report server. I got the same issue and everything works fine in excel

    I connect via credentials and impersonation and  haven't setup kerberos authentication as this shouldn't be necessary.

     

    I woould just like to know if it has been diabled on purpose or if it is an error we can expect to be soved. 

     

     

    /rkri

     

  • mapko's avatar
    mapko
    Helper I
    9 years ago

    rkri000, how are you testing this on the report server? If with your own account (that also has admin priviledges on the analysis service instance) then RLS will not work. The moment I removed myself from the instance's admin role RLS worked.

  • rkri000's avatar
    rkri000
    Frequent Visitor
    9 years ago

    mapko

     

    Thanks it helped. I have forgotten to turn if of for the test users. The behaviour is a little different than usual.. The test user gets a an error. The permission granted to user ----- are insuffient for performing this operation. But that is okay

     

    Thanks 

     

    /rkri000