Forum Discussion

DanielFountain's avatar
DanielFountain
New Member
10 years ago
Solved

Row Level security

Hey all,   I am getting a little confused with row level security.   So i understand you can only implement this if you use SSAS is that correct?   I dont understand how this works - so could s...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi Dan,

     

    You need to utilise the Analysis Services Live Connector for this scenario.  You can find more info here:

    http://blogs.msdn.com/b/powerbi/archive/2015/03/11/power-bi-analysis-services-connector-deep-dive.aspx

     

    In this arrangement, no data is stored in the cloud.  Power BI converts your request to a DAX query, and sends that query (along with your AD info) to the Tabular model who duely executes the query applying the appropriate Row Level Security.

     

    Hope this helps

    Sacha

     

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Dan,

 

You need to utilise the Analysis Services Live Connector for this scenario.  You can find more info here:

http://blogs.msdn.com/b/powerbi/archive/2015/03/11/power-bi-analysis-services-connector-deep-dive.aspx

 

In this arrangement, no data is stored in the cloud.  Power BI converts your request to a DAX query, and sends that query (along with your AD info) to the Tabular model who duely executes the query applying the appropriate Row Level Security.

 

Hope this helps

Sacha