Forum Discussion

mittalpatel130's avatar
mittalpatel130
Icon for Helper III rankHelper III
6 years ago
Solved

SSAS Tabular model Row Level Security is not working in Power BI Desktop

Hello -    We have set up a SSAS Tabular Model and created 2 roles as below.    1. Admin - Administrator, Full Control 2. Employees - Read Only   There are 2 users added as members in Employee...
Need Help
mittalpatel130's avatar
mittalpatel130
Icon for Helper III rankHelper III
6 years ago

Hello Leed,

 

I'm using simple Row level security with a filter condition on tables.. like Country = 'US' .. 

 

It is not a dynamic security. Still your comments apply to it? I'm little confused on where to add that USERPRINCIPALNAME()? On DAX filters or in members of the Role? 

 

Thank you very much for your response!

leed's avatar
leed
Icon for Advocate II rankAdvocate II
6 years ago

mittalpatel130 

2 screenshots :

1/ where to add membership.

1/ 

 

2/ where to add USERPRINCIPALNAME()

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    leed 

     

    I see your screen shots. Which version of SSAS is that? I am using 2016 SSAS Tabular and dont see UserPrincipalName(). 

    Do higher version of SSAS has this DAX function?

     

    Thanks

    Manoj

    • leed's avatar
      leed
      Icon for Advocate II rankAdvocate II
      6 years ago

      Hi Anonymous 

       

      This is a pretty basic DAX function, I think it's avaialable on all the version.

      Whatever, below is the detail of my SSAS tabular server.

       

      Best,

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi leed 

         

        Thanks for you response.

         

        Your version is 14.0.6.443 - This is 2017 SQL Build Version

        My version is 13.0.5201.2 - This is 2016 SQL Build version.

         

        But compatability is 1200 which is supported from 2016.

         

        So i need to conclude that in 2016 SSAS Tabular, userprincipalname() DAX function doesnt work, like said in many other forums.

         

        Thanks

        Manoj