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

[Optimusprime_25]

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.

[Deepanshu_46]

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.

[amitchandak]

@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]

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.