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

      • BananaLee's avatar
        BananaLee
        Frequent Visitor
        9 years ago

        Hi arify,

         

        I've just gotten into PowerBI Desktop and am trying to connect on an ODBC driver. I'm having the same problems and looking at the logs, there doesn't appear to be a "restricted data" line in the logs at all. 

        I'm also struggling a little with sending a frown e-mail since I can't seem to find the place to click in order to do so but I do have some logs which would be useful.

        EDIT: Just realised you were referring to the PowerBI interface - frown e-mail sent.

         

        The SQL workaround works but I'd be quite keen to be able to use the functionality without having to type up SQL (it's a very large database with many links)