Forum Discussion

Henrik's avatar
Henrik
New Member
10 years ago

odbc error "Restricted data type attribute violation"

Hello, in Power BI Desktop (Version: 2.36.4434.381 32-bit) I want to connect to an Oracle data base via odbc. I do have an ODBC data source set up, which so far worked fine in any application (Acce...
VRENEE's avatar
VRENEE
Frequent Visitor
10 years ago

Hello,

 

I have got same message with Oracle database thus it is OK in EXCEL 2010. Strange it does not work with POWERQUERY so (EXCEL addin and POWERBI DESKTOP). What is to say ?

Thanks in advance.

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    Hi VRENEE,

     

    Have you used the latest version of PBI Desktop? Can you please send us a frown with the trace files like I've described above?

     

    Thanks

    • VRENEE's avatar
      VRENEE
      Frequent Visitor
      10 years ago

      Hello,

       

      Of course yes ...even older versions.

       

      I have tried to use ODBC with POWERQUERY 2010 EXCEL addin and an error occured something similar to powerbi.

      Therefore I noticed ODBC connexion, in 2010 EXCEL version, activated by datatab assistant works fine.

      I copied the properties and parameters generated with this connexion and also the SQL : select * from mytable and it works fine in POWERQUERY. Tried into POWERBI … also fine.

      I read a lot of things and blogs about this problem around POWERQUERY and ODBC and came to the conclusion that to work with ODBC driver into POWERBI I have to use my tnsname (of course) but give also a select clause in option tab and now it is OK.

      When I have expanded the M language generated, it shew an odbc.query instruction while it was an odbc.datasource at first without SQL clause.

       

      What I have read tend to explain that it was a “normal ODBC driver dysfunction” as there were some restrictions. The advice was to use ORACLE driver as far as possible. But as the workaround above it is OK for me. 

       

      Hope it helps.

       

      Regards.

      • arify's avatar
        arify
        Microsoft Employee
        10 years ago

        Hi VRENEE,

         

        It is completely up to you, if you're happy with the work around :) But if we could get the traces about the details of this error, we can give you a much better experience in the future for this ODBC driver.

         

        Thanks