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

[abhishek_rana]

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

[v-yetao1-msft]

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]

Hello @v-yetao1-msft , 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.