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

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
Microsoft Employee
Microsoft 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