Can't connect gateway to data source

[chaima]

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 the other one is windows server 2016. I have installed the gateway on the windows server but when I try to connect to the MySQL database I'm getting an error "we could not register this data source for any gateway instances within this cluster" I was able to connect with ODBC to my PBI desktop that I install on this server so connection can be established.

I tried to connect to SQL server MySQL ODBC. all gave me the same error.

Thank you,

Chaima

[Anonymous]

Hi @chaima ,

I found some topics about the same error message, please see if it helps.

https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=fals...

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[chaima]

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]

@chaima Maybe you can raise a support tickte and troubleshoot the issue, directly with Microsoft.

[chaima]

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.

[Thomas_PBI]

did you solve this finally? Happened to my dataset as well