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 Liv...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 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
    7 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
      7 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!
      • saykasku's avatar
        saykasku
        Icon for Resolver I rankResolver I
        7 years ago

        Hi,

         

        Try this:

        1. Create pbix with measure USERNAME()

        2. Check result string

        3. Upload this pbix to RS

        4. Check result string on RS

        5. Compare them.

         

        Are they same strings?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Manoj,

       

      We are also have same kind of requirement which u have.

      Data filtering not happening using SSAS Tabular RLS Live connection to Power BI report Server- On Premises .

       

      1. Power BI report Server - Jan 2020 version - On-Premises 

      2. SSAS Tabular Model Live connection. version 2019.

      3. Power BI desktop - Jan -2020

       

      I have implemented custom authentication where will allow the access to power BI report server.

      And Live connected to Analysis services tabular model for testing purpose signle table like employee table (employeeid, name , email, department).

      Created Role where hard coded value to filter departmentId=1.

       

      But the probem is data is not filtering in power BI report server as well as Power BI desktop.

       

      could u please help us for where we have made mistake.

       

      Thansk,

      Suresh

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Suresh,

         

        Did you try userprinciplename() function and create a role in Roles of SSAS Tabular model. This will usually relate to user email, so map it to email field.

         

        Thanks

        Manoj