cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

OLE DB or ODBC error: [Expression.Error] Local evaluation of join with key equality comparers

Hi PBI Community, 

 

I'm currently stuck with the following error: 

Screen Shot 2020-02-20 at 3.00.33 pm.png

 

Backstory

I am attempting to create a report in PBI Desktop (February 2020) with a DirectQuery connection to a PostgreSQL database. I have 5 tables within the report (a centralised Date table and 4 e-commerce data tables, all of which have a Date column). I am able to build visualisations within the report with data from the various tables individually without any problems but when I make a relationship in the data model between the DateTime table and any of the e-commerce tables (necessary) I get the above error. 

 

Trouble-shooting thus far

Trawling through the interwebs, some posts have vaguely suggested that this error may be due to trying to join mixed data types (I can confirm all of the Date columns I'm trying to relate are of the same underlying format) or joinAlgorithms (I don't have any table joins or merges, as far as I am aware)(@ImekF solved this one, might be able to help here?).

 

I am at a loss.  I include below a sample of data for each table.

 

Date table

Screen Shot 2020-02-20 at 3.21.20 pm.png

 

 

 

 

E-commerce tables follow same format as below

Screen Shot 2020-02-20 at 3.28.45 pm.png

 

Hopefully someone can help, and many thanks in advance!

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: OLE DB or ODBC error: [Expression.Error] Local evaluation of join with key equality comparers

Hi @nkh ,

 

I always try to avoid DirectQuery mode or reduce it to simple queries.

Hence my questions:

- Do you really need DirectQuery mode?

- Can you merge the queries with SQL beforehand?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

Highlighted
Frequent Visitor

Re: OLE DB or ODBC error: [Expression.Error] Local evaluation of join with key equality comparers

Hi @mwegener ,

Thanks for your reply.

 

The purpose of this report is to provide near-real-time-data to stakeholders in our business, and given that we are using Pro licences (read: 8 times/day refresh not timely enough), DirectQuery is necessary. 

 

I will look into the viability of combining the data into one SQL query but if we can find a PBI solution or at least an explaination for why this error is occurring that'd be great. 🙂 

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors