Forum Discussion
mtstewart17
Advocate I
Advocate IEnterprise Gateway with ODBC
Hello, I have an ODBC source that I use for several Dashboards. I would like to setup a Gateway in order to keep the data up to date. The source is an IBM DB2 database. (I know that connecting st...
Hi mtstewart17,
Based on your description, you want to add ODBC data source under gateway. In this case, you can input the connection string following the steps below.
1. Check your DSN name(testodbc1 in my scenario) in ODBC administrator or in Power BI Desktop if you have connected to the odbc data source from Power BI desktop.
2. Add data source under gateway by entering connection string , account and password as shown in the following screenshot .
3. Schedule refresh for the dataset in Service.
In addition, please ensure that you create a system dsn in ODBC administrator .
Thanks,
Lydia Zhang