Forum Discussion

Optimusprime_25's avatar
Optimusprime_25
Icon for Resolver I rankResolver I
3 years ago

Local evaluation of Table.Join or Table.NestedJoin with key equality comparers is not supported

Hi Team,

 

We are facing issues with the report for which we have applied dynamic RLS based on country and group. Till yesterday it was working, but not sure why it is not working now. 

We are getting below error in the report.

 

 

Below is the datamodel

 

Below is the DAX logic which we have applied in the manage roles

 

country filtering

 

product filtering

 

Please look into this and provide the solution for the issue.

 

Thanks in advance.

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Optimusprime_25 , is user_id is email, because userprincipalname will be an email( unless you are using embedded power bi)  and will be text format, so please check for any data type changes or value changes

    • Optimusprime_25's avatar
      Optimusprime_25
      Icon for Resolver I rankResolver I
      3 years ago

      Hi amitchandak ,

       

      Thanks for your response.

       

      Yes user_id is an email we are using in the table reports_users.

       

      We haven't changed any data types. So, not sure where it is breaking.

       

       

  • Deepanshu_46's avatar
    Deepanshu_46
    Regular Visitor
    2 years ago

    Did you get it resolved? I'm also stuck in the same issue and unable to resolve it. Your help with this would be highly appreciated.I am using Direct query connection with snowflake.