Forum Discussion
Error in power bi data gateway
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
2 Replies
- amitchandak
Super User
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 - v-easonf-msft
Community Support
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
