Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SSAS Live connection with row level security on Report Server

Hi,

 

I am using SSAS Tabular model created and using in Power BI report server. We have new security requirement of users logging and what they get to see in report.

 

When i connect to SSAS Live, i see the power roles is disabled. So i implemented in SSAS so that report should filter for the user logged in.  Once I deploy the report the Report server, i dont see any user filteration happening, and also on server report manage section, row level security is disabled.

 

I did read this - https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular

But it talks only about Power BI service.

 

Can some one provide insight on how to acheive this on Report server, when we use SSAS Tabular Live connection in Power BI Report server?

 

Thanks

Manoj

 

 

Need Help

11 Replies

  • saykasku's avatar
    saykasku
    Resolver I
    7 years ago

    Hi,

     

    Do You have both services (SSAS and RS) on one machine?

    If u don't have u need SPN to authentificate AD users.

     

    Do You have same accounts in row level security in pbix and in row-level tab on RS in this report?
    If not u need to add it.

     

    Remember about that:

    In Power BI Desktop function USERNAME() will return "<domain>\<user>"

    In Power BI Report Server  function USERNAME() will return "<user>@<domain>"

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi manalla,

     

    hope you doing well, I am having the same issue, and I appreciate if you help me out finding the solve 

    thank you

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous 

       

      I had the issue resolved.

      Setup the Roles in SSAS Tabular layer. And then based on the user logged in, RLS will be applied from PBI RS to SSAS.

       

      Let me know your exact issue, so that i can help as much i can.

       

      Thanks

      Manoj

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        Dear Anonymous
        I tried to create a rule on SSAS layer and when I login into PRS with the same account the i had made the rule on , It doesn’t filtering the data the way I want, it still shows me the whole data
        Could you help me please!