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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

mapko The role wouldn't be there if you imported, and you wouldn't have RLS, you would have to recreate it in the Desktop file. (which is why I asked).

Is the user you are sharing with an admin on the server, or somehow have elevated permissions that would override any RLS setting?

I'm also assuming you are looking users up by their <domain>\<username>

I don't see anything that would lead me to believe this wouldn't be supported...

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