Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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!

4 REPLIES 4
Deepanshu_46
Regular Visitor

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.

mwegener
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous ,

 

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.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials


Anonymous
Not applicable

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. 🙂 

Any news?

Maybe a fix/workaround?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.