Forum Discussion

PowerBIBeginer's avatar
PowerBIBeginer
Helper 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
Helper 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
Super 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