PowerBI Gateway - specific ODBC setting on gateway

[nyates]

Hi,

hope someone has a great idea for our issue with a required odbc setting on the local gateway server.

Initial situation: The customer uses the PowerBI Gateway to acquire local data sources - type: IBM Informix Database. 

Issue: The connection to the Informix server requires a special odbc setting. Can a local odbc setting be made on the local Gatway server? 

Many thx for your support! 

[sandygather]

In Case we paste a System DSN in the connection string, does the DSN need to be defined on the Gateway server?

[v-xiaoyan-msft · Accepted solution]

Hi @nyates ,

Follow these steps to set up the Power BI gateway for ODBC data sources.

1.Download the latest Power BI gateway.

2.Install the 64-bit ODBC driver that you plan to use on the gateway machine.

3.To configure an ODBC data source in the Manage Gateway page of the Power BI Service, select Add data source > ODBC Data Source Type

4.Paste in the connection string (System DSN or driver) and select an authentication method.

5.When you select the Add button, the Power BI service connects to the ODBC data source using the supplied connection string and credentials to validate that the gateway is able to connect.

For more information，you may refer to Install Power BI gateway, configure ODBC data sources 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[nyates]

Great - I will try the suggested settings and will get back to you. 

THX

Nik