Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

bogomda

DataSource.Error: ODBC: ERROR [07006] [Oracle][ODBC]Restricted data type attribute violation

Submitted by Resolver I on ‎01-12-2017 11:27 AM

Hello,

in Power BI Desktop (Version: 2.41.4581.361 32-bit (November 2016)) 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 application MS Access 2016 and MS Excel 2016. In Power BI, however, I get an error.

At first the connection seems to wok fine, I get a list of all tables in the data base as expected. But when I try to load a table, the following error message comes up:

 

DataSource.Error: ODBC: ERROR [07006] [Oracle][ODBC]Restricted data type attribute violation.

Details:

   DataSourceKind=Odbc

   DataSourcePath=dsn=LAWRPT90

   OdbcErrors=Table

 

However, if in settings in SQL statement optional field I put something like SELECT * FROM TABLE_NAME I can access specific table. This could be a workaround for me but it’s very inconvenient approach

 

I have same issue connecting in Power Query or Power Pivot in Excel 2016.

 

Is there a way to fix this problem?

 

Thanks, Danil

Status: Needs Info
See more ideas labeled with:
14 Comments (14 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎01-15-2017 11:25 PM

@bogomda

 

Could you please try with the latest Jan 2017 version to see if the issue persists?

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎01-15-2017 11:26 PM
Status changed to: Needs Info
 
bogomda
Resolver I
Resolver I
‎01-16-2017 06:40 AM

Herbert,

 

just checked and the the issue still persists with the latest January 2017 Power BI Desktop.

 

Bogomda

bogomda
Resolver I
Resolver I
‎02-11-2017 12:00 AM

Feb realese doesnt fix the problem

javitodepinypon
New Member
‎03-07-2017 09:03 AM

same problem here...

Nikunjryder
Regular Visitor
‎03-20-2017 09:06 AM

same problem has anyone find solution??

i am getting the below error:

 

DataSource.Error: ODBC: ERROR [07006] [AR System ODBC Driver]Conversion error
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=AR System ODBC Data Source
    OdbcErrors=Table

jrussi
New Member
‎04-06-2017 10:12 AM
Same problem here, with Excel Power Query. DataSource.Error: ODBC: ERROR [07006] [Oracle][ODBC]Restricted data type attribute violation. Any solution?
Nikunjryder
Regular Visitor
‎04-06-2017 10:26 AM

No solution at all Yet. Microsoft needs to step in and help us but i dont know if anyone is looking at this post.

bogomda
Resolver I
Resolver I
‎04-06-2017 10:41 AM

Power BI technology is great but useless for me until this issue is resolved. i can't connect to my data source which is fundamental problem.

 

Microsoft, please help!!!!! 🙂

MartinBerke
New Member
‎08-02-2017 09:33 AM

Still no solution for this Problem?

Thanks for an answer

Idea Statuses