Forum Discussion
Helper IIIRLS with USERELATIONSHIPS all over the place
Helper IIIThank you amitchandak
However the Dynamic RLS does not solve my problem as the issue appears to be beyond that
All tutorials and pages I´ve found present cases of RLS for extremely simplified models
(simply showing part of the data and/or measures/columns involving simple DAX functions)
The nature of my problem appears to be a fundamental limitation, where more high-level DAX is not allowed
(involving CALCULATE, ALLEXCEPT, USERELATIONSHIP and so on....)
Is there a solution to this? Thank you to all you can provide some further support/insight
Community SupportHi andrea_chiappo ,
When using dax expression to define RLS in power bi desktop, most dax functions are available except you cannot use it to create a virtual table becasuse RLS filters all fact tables.
As for you cannot use functions like calculate, I don't think so. Refer to my following expression in the picture using the calculate() function is RLS:
This role defines each person can show their own datas under a manager-hierarchy level, sample file attached that you can refer:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- andrea_chiappo
Thank you for your reply v-yingjl
I realised that I did not explain myself properly. I will modify the question from the start.
- v-yingjl
Hi andrea_chiappo ,
Could you please consider sharing a dummy .pbix file or your rls role expression which uses userelationship() and crossfilter() for further discussion? Maybe it can be written as another way to avoid this error.
Best Regards,
Yingjie Li- andrea_chiappo
the rls expression is simply: [email] = "[email protected]"
If you kindly check the update version of the post you will find a detailed explanation of the situation.
No USERELATIONSHIP or CROSSFILTER appears in the rls expression. The issue is in the model and appears to be a limitation of DAX