Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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:    Backstory I am attempting to create a report in PBI Desktop (February 2020) with a DirectQuery connection to a Postgre...
Need Help
mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

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?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

    • amirh's avatar
      amirh
      New Member
      6 years ago

      Any news?

      Maybe a fix/workaround?