Error in power bi data gateway

[tsw129]

Hi experts,

When I configure the gateway on power bi website I got the error below. For your information, I used ODBC to connect the OBM ERP database, and install and configure data gateway inside the server, but still unable to connect. Please advise.

Thank you.

Underlying error code: -2147467259
Underlying error message: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath: dsn=Centrionics
Microsoft.Data.Mashup.ValueError.OdbcErrors: #table({"SQLState", "NativeError", "Message"}, {})
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-SOUTH-EAST-ASIA-B-PRIMARY-redirect.analysis.windows.net
Activity ID: a37b9af6-d63f-4015-bffc-467d1d125356
Request ID: 73e31045-1973-f9c5-1ec4-db1896a2b1fe
Time: 2022-03-25 09:42:36Z

[v-easonf-msft]

Hi, @tsw129 

Please re-verify the data source credential of the odbc configured under the gateway.

You can also refer to this article.

Power BI gateway and Report Builder support for ODBC data sources 

Best Regards,
Community Support Team _ Eason

[amitchandak]

@tsw129 , Seem like the driver has some issues - "Data source name is not found and no default driver is specified. " Please check and install a correct driver on the gateway machine

refer if needed

Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk