Forum Discussion

abhishek_rana's avatar
abhishek_rana
Regular Visitor
5 years ago

Dynamic Row Level Security on Analysis Services being accessed through Power BI Desktop

I am applying Dynamic RLS on Analysis services. The idea is to access it through Power BI Desktop (Live Connection).

Based on the User Logged on, row level security has to be applied.

As a next step, will deploy it to Power BI services for consumers to use this data based on their data access.

 

Issue - Dynamic RLS does not work on Power BI Desktop

 

 

 

Power BI Report made through live connection on Analysis services

 

Issue - Would like to receive only one row where RXA.CH as I am the logged in user (RXA.CH)

 

LOGINCODE - is a database table

WindowsInitials - is a measure - (WindowsInitials:=Upper(Left(USERPRINCIPALNAME(),Search("@",USERPRINCIPALNAME())-1))

where Userprincipalname() is 

 

RLS applied on the Analysis Services data model - 

 

 

Please help.

 

Best Regards, Abi

Need Help
Show and Tell

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi abhishek_rana 

    You said you want to receive only one row where RXA.CH as you are the logged in user (RXA.CH), so what’s the result that you see in the desktop ?

    Could you provide more data about your sample ?

    Maybe you can refer to the link , it may provide you with some useful information .

    Dynamic row-level security with Analysis services tabular model - Power BI | Microsoft Docs

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • abhishek_rana's avatar
      abhishek_rana
      Regular Visitor
      5 years ago

      Hello Anonymous , Thank you for your reply.

       

      Below is the result which I see instead -

       

      I would like to see the result only where login code is RXA.CH.

       

      As of now, I see the login code of all the members of the Role which should not be the case, as you can see in my original email the DAX code in the Row filter: LoginCode=WindowsInitials.

       

      I have already gone through the post suggested by you (and many others) - 

      Dynamic row-level security with Analysis services tabular model - Power BI | Microsoft Docs

       

      As suggested in this post, I modified the DAX code for Row Filter to refer to Lookup function but that too did not help.