Forum Discussion
Connecting to Informix DataBase with instance name
Hello, how can I put the instance name on a informix connection. At sever field I put: myserver:myPort At DataBase I put: myDataBaseName But I couldn't found where I can put the instance server...
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.