Forum Discussion

andrea_chiappo's avatar
andrea_chiappo
Icon for Helper III rankHelper III
6 years ago

RLS with USERELATIONSHIPS all over the place

Hi Power BI experts,   NEW VERSION   The data source in my Power BI file are Excel workbooks, one for every client of the company I'm working for.   I built several report pages, where all visua...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
andrea_chiappo
Icon for Helper III rankHelper III
6 years ago

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