I am trying to connect an IBM Informix database to Power BI using ODBC.
The connection itself is successful, but I cannot see any tables or views.
Possible Issues?
Am I missing specific permissions?
Are there any special settings required for Power BI or ODBC?
Is this a known issue, and are there any workarounds?
Has anyone encountered this issue before or has an idea how to fix it?
Any help would be greatly appreciated!
What I have done so far:
Set up the ODBC DSN for IBM Informix in the ODBC Data Source Administrator.
Tested the connection with Microsoft Access → I can see all tables there.
In Power BI, went to Get Data → ODBC, selected the DSN, and connected.
The connection is established without errors, but no tables are displayed.
I am trying to connect an IBM Informix database to Power BI using ODBC.
The connection itself is successful, but I cannot see any tables or views.
Possible Issues?
Am I missing specific permissions?
Are there any special settings required for Power BI or ODBC?
Is this a known issue, and are there any workarounds?
Has anyone encountered this issue before or has an idea how to fix it?
Any help would be greatly appreciated!
What I have done so far:
Set up the ODBC DSN for IBM Informix in the ODBC Data Source Administrator.
Tested the connection with Microsoft Access → I can see all tables there.
In Power BI, went to Get Data → ODBC, selected the DSN, and connected.
The connection is established without errors, but no tables are displayed.
powerbi
odbc
informix
Share
asked Mar 4 at 7:20
keleschkelesch1111 bronze badge1
When you say "cannot see any tables or views", what are you using to try and see them? Are you executing queries such as "SELECT * FROM Known_Table" or are you trying to use ODBC metadata functions to find out what tables and views are present? Are you using an Informix ODBC driver, or some other party's driver?
– Jonathan Leffler
CommentedMar 5 at 0:31
Add a comment
|
1 Answer
1
Reset to default
0
Whose Informix ODBC Driver are you using ?
Have you tried with OpenLink Informix ODBC Drivers, as they do work with Power BI, listing the Tables in the target database on connect and allowing them to be selected and queried within Power BI.
SELECT * FROM Known_Table" or are you trying to use ODBC metadata functions to find out what tables and views are present? Are you using an Informix ODBC driver, or some other party's driver? – Jonathan Leffler Commented Mar 5 at 0:31