Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
3 years ago
Solved

errror

Hi All, I'm getting error. Pls look below screenshot.. Can anyone guide me in deatil...  
Need Help
  • Idrissshatila's avatar
    Idrissshatila
    3 years ago

    PowerBIBeginer 
    okay , look at the tables that emaster has a relation with and then look at the column that the relationship is made with, it should have the same type in both tables.


    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

    Follow me on Linkedin

PowerBIBeginer's avatar
PowerBIBeginer
Icon for Helper V rankHelper V
3 years ago

Im sorry first, I did not appriciate your reply (bcoz of the unnecessary frustration)..

 

Thanks for your reply.. since yestreday, I did all this checks, and nothing found.. really dont understand what going wrong.. error is also not very specific to found out

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

PowerBIBeginer ,

 

check if these would help

 

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-Type-mismatch-Exception-from-HRESULT/m-p/648728

 

 

https://knowledge.exlibrisgroup.com/Voyager/Knowledge_Articles/Receive_the_%22Type_mismatch_in_expression%22_error_when_running_a_query_in_Voyager_Prepackaged_Access_Reports

 

https://community.powerbi.com/t5/Desktop/ISOLATING-ERROR-OLE-DB-or-ODBC-error-type-mismatch-exception/m-p/2886469

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin