Forum Discussion
Can't connect gateway to data source
Hi, I have a problem to connect my PBI gateway to a data source I checked around and try a few solutions with no success. I have 2 servers in the cloud. one is Debian 9 with MySQL database and t...
Hi Anonymous Jay,
Thank you for your reply, I looked in the solutions but it didn't help. here are the error details I get:
| Activity ID: | 21c1f6bc-19e9-4196-af83-65ff96a3e5ed |
| Request ID: | b05713d8-359c-ca24-17bb-dea8b618e31a |
| Cluster URI: | https://wabi-west-europe-b-primary-redirect.analysis.windows.net/ |
| Status code: | 400 |
| Error Code: | DMTS_PublishDatasourceToClusterErrorCode |
| Time: | Thu Jan 30 2020 09:02:24 GMT+0000 (Greenwich Mean Time) |
| Service version: | 13.0.12023.283 |
| Client version: | 2001.1.013 |
| test1: | Unable to connect to the data source undefined. |
| 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=x |
| Microsoft.Data.Mashup.ValueError.OdbcErrors: | #table({"SQLState", "NativeError", "Message"}, {}) |
| Microsoft.Data.Mashup.ValueError.Reason: | DataSource.Error |
Anmolgan
Post Prodigy
Post Prodigychaima Maybe you can raise a support tickte and troubleshoot the issue, directly with Microsoft.
Already did. they escalate it to the dev team.
I was able to connect the power bi with personal getaway but not with the enterprise gateway.
Hope to hear from the support soon.
Thank you.
did you solve this finally? Happened to my dataset as well