Forum Discussion
ODBC Gateway Setup fail!
Hi,
1) the base info : PBI - Pro, Gateway - On-premises
2) I learned about the community's thread on this issue https://community.powerbi.com/t5/Service/Can-t-connect-ODBC-datasource-to-gateway/m-p/797173
3) and do the everything follow up its instructions
4) The PBI Desktop connect the ODBC datasoure successfully!!
5) connection string I setup as "dsn=pbi_bpcsf" since the powerquery shows as the following,:
and gateway schedule show is :
"ODBC('connectionstring:dsn=pbi_bpcsf')"
6) ODBC data source administrator - both(32-bit) and (64-bit) all have setup.
Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
| Activity ID: | a398f15a-15c3-4bd8-b3b1-44cc9ee65a48 | ||||||||||||||||
| Request ID: | dda9fab1-2b91-b072-1253-88043abe5f5a | ||||||||||||||||
| Cluster URI: | https://wabi-west-us-redirect.analysis.windows.net/ | ||||||||||||||||
| Status code: | 400 | ||||||||||||||||
| Error Code: | DMTS_PublishDatasourceToClusterErrorCode | ||||||||||||||||
| Time: | Sat Jul 18 2020 21:52:21 GMT+0800 | ||||||||||||||||
| Service version: | 13.0.13860.51 | ||||||||||||||||
| Client version: | 2007.1.01830-train
|
You need to successfully connect to your data source via ODBC on the gateway VM before you can proceed to create the connection on the gateway. The ODBC system dialog has a "Test" option. You can use that, or install a database client on the gateway VM for the test.
13 Replies
Can you connect via ODBC on the gateway?
You need to successfully connect to your data source via ODBC on the gateway VM before you can proceed to create the connection on the gateway. The ODBC system dialog has a "Test" option. You can use that, or install a database client on the gateway VM for the test.