Forum Discussion
Connecting to Informix DataBase with instance name
Anonymous,
In server field you can input: ServerName/InstanceName: Port
In Database field you can input: DatabaseName
Regards,
Jimmy Tao
v-yuta-msft, it doesn't work. Power BI try to resolve "hostname/instance" as a hostname, so a I receive a message unknown host. This works like a charm with others db's like Oracle.
Anonymous,
In your senario, I would recommend you to use ODBC connector with connection string instead and try again. For more details about ODBC, please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-connect-using-generic-interfaces#data-sources-accessible-through-odbc.
Regards,
Jimmy Tao
v-yuta-msft, unfortunately Power BI don't list schemas and tables of Informix ODBC connection. See the picture bellow. I did a test in Excel with same ODBC connection and everything worked fine. In Excel I could see all tables, but not in Power BI.
Anonymous,
Have you solved the issue currently? If still can't resolve it, I would suggest you to create a support ticket to achieve deeper help.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.