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