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

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'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