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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Nikunjryder

Connecting BMC Remedy with POWER BI

Submitted by on ‎03-08-2017 02:31 PM

I am trying to connect power BI via ODBC connection for BMC Remedy application.

 

i am able to see all the tables, but wheni try to select the table it gives me error as below:

 

 

DataSource.Error: ODBC: ERROR [07006] [AR System ODBC Driver]Conversion error

 

Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=AR System ODBC Data Source
    OdbcErrors=Table

 

can anyone please tell me how cani troubleshoot this error?

Status: Needs Info
See more ideas labeled with:
6 Comments (6 New)
Comments
v-haibl-msft
Employee
Employee
‎03-09-2017 10:36 PM

@Nikunjryder

 

Can you connect and select the table properly via Excel ODBC connection in the same machine which Power BI Desktop is installed?

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎03-09-2017 10:37 PM
Status changed to: Needs Info
 
Nikunjryder
Regular Visitor
‎03-10-2017 06:39 AM

hello Herbert,

 

i am just connecting power BI via ODBC connection, putting my credentials for ODBC and i can see all the tables but when i select them its giving me that error.

 

I am not getting what you trying to suggest? connect my application in excel and then connect power Bi? how does that work?

 

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

yes i am able to connect my ODBC connection in excel but in power BI i am getting this error

 

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

Anonymous
Not applicable
‎03-15-2019 10:31 AM

I see same trouble, but i have no ideia how solve it.

ismrdelj
Regular Visitor
‎10-18-2022 02:59 AM

 

I have the same problem -  has anyone managed to solve this issue ?

Idea Statuses