Forum Discussion
RLS doesn't work with bidirection dax
We are working with Power BI to create self service report and want to limit access based on login user. But it is not all that straight forward. Here's our security model: Have 4 tables ...
Thanks for checking!! DAX above works. But we face another issue, The record count (for AreaCustEntity) is different when RLS was applied through AreaUser to that of now where RLS is applied on Entity. All other tables in the model are filtered via AreaCustEntity so now we are not sure how we can fix this.
Can I reach you over mail for queries, anyway i am available at [email protected]
Hi,
Sure..
for example, When RLS is applied theough AreaUser total count of AreaID in report layer is different than when RLS is applied through Entity table using above DAX.