Forum Discussion
Local evaluation of Table.Join or Table.NestedJoin with key equality comparers is not supported
Hi rkoffice ,
The error indicates that Power BI cannot evaluate the join operation locally due to the presence of key equality comparers, which are intended for internal use only and not supported in the Power BI Service environment.In Power Query, right-click each step and choose View Native Query.
If this option is disabled at any step, query folding is broken.
Try to remove Value. Native Query. from M expressions as it can interfere with query folding.
If folding cannot be preserved, consider switching the affected tables to Import mode instead of DirectQuery.
Hope this helps!
Community SupportHi rkoffice ,
The error indicates that Power BI cannot evaluate the join operation locally due to the presence of key equality comparers, which are intended for internal use only and not supported in the Power BI Service environment.
In Power Query, right-click each step and choose View Native Query.
If this option is disabled at any step, query folding is broken.
Try to remove Value. Native Query. from M expressions as it can interfere with query folding.
If folding cannot be preserved, consider switching the affected tables to Import mode instead of DirectQuery.
Hope this helps!