Forum Discussion

toddpbi's avatar
toddpbi
Helper II
8 years ago

Row Level Security

Hello there.

 

Currently I am trying to implement row level security on my data model. My company is not allowing the usage of Power BI service, which rules out any chances of me being able to use Cloud Services offered by Microsoft.

 

Is there any other alternatives to be able to implement RLS into my model? I have heard about using dynamic row level security in SSAS Tabular Models, but the end result still is publishing the model to the Power BI cloud. I only have access to an SSAS Tabular Model and an onPremise PowerBI Report Server.

 

Any guidance on this matter would be of great help to me.

Thanks,

Report server RLS row level security

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago
    Hi toddpbi,

    We have used SSAS Tabular RLS with Power BI RS On-Prem. Works well, I'm not sure why you think you would still need to publish to the cloud, I might be missing part of your requirement?

    Regards
    Rob

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous Sorry to ask but have you really been able to use RLS SSAS with Power BI Report Server? How did you do that? How did you get the role been recognized in Power BI?

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago
        Hi Anonymous,

         

        Yes honest we have, it works well. :)

         

        There are a few pre-requisites

         

        You have to be using windows active directory domain user security, and your PBI users need to be authenticated logged in users.

         

        We are using the Oct 2017 PBI Desktop and PBIRS on-prem, on a server on the domain. Not sure if it works with versions earlier than this.

         

        We have SQL Server 2016 SSAS Tabular supporting our data model. And we use the SSAS Tab DM as the data source for the PBI report. Not a DM in PowerBI. (Direct Query like connection)

         

        The roles are created and managed in SSAS Tabular, PBI is just the consumer.

         

        We do have the SQLserver, SSAS Tab service and PBIRS all running on the same server. I think there maybe some extra setup needed if you distribute these elements.

         

        There are some online resources for this, try Guy In A Cube for example.

         

        Hope that helps

        Rob