Forum Discussion
DirectQuery in Composite Model
Hi. I have a composite model with direct queries that looks like this When I try to make a table visual with user_action metrics and aggregation by country, I get the following error: OLE DB ...
I've just hit this issue after adjusting some formatting settings for Date values. After making that change a number of visuals which were loading previously, fail to load and the details show the "Local evaluation of Table.Join or Table.NestedJoin with key equality comparers is not supported".
One of the visuals affected doesn't reference any of the changed columns at all.
The puzzling thing to me is that Power BI appears to have convinced itself it can't do a thing that it was doing previously.
The error message could certainly benefit from detailing what tables it was trying to join and what keys it was referring to.