Forum Discussion
Solved
Local evaluation of Table.Join or Table.NestedJoin with key equality comparers is not supported
I'm facing an issue after publishing my Power BI report to the Power BI Service. The report runs perfectly fine in Power BI Desktop, but once published, I receive the following error: Expression....
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!
