Hi,

I am unable to connect to a mysql server port using powerquery, whereas I am able to connect to a server which connects to the default port itself. If I have to connect to the server with a port different from the default one, what should I do?

Regards,

Venu

Hi,

Do you get the error message/code when you access MySQL server? Like this:

DataSource. Error: MySQL: Unable to connect to any of the specified MySQL hosts. Details: Message=unable to..., ErrorCode=-2147467259"

It might be related to the .NET connector. Please try to updating the version to 6.8.3.

Similar issue:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a61cb1c6-9668-4900-82d1-d034021ebaff/cannot-connect-to-mysql-w-power-query-excel-2010?forum=sqlkjpowerpivotforexcel

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a61cb1c6-9668-4900-82d1-d034021ebaff/cannot-connect-to-mysql-w-power-query-excel-2010?forum=sqlkjpowerpivotforexcel

More reference:

http://office.microsoft.com/en-ca/excel-help/connect-to-a-mysql-database-HA104019820.aspx

Regards,

George Zhao
TechNet Community Support

Hi,

Thanks for the reply.

I am getting the same error you mentioned above. but updating to the version 6.8.3 didn't solve my problem. 

I am able to connect to mysql server when i give the server name. but if i have to connect using port number, it's not working for me.

can you please let me know how to connect to a mysql server port using powerquery?

Example

Server: localhost   (this is working)

Server: localhost,3306 (this is not working)

Thanks,

Venu

no, we cannot use the excel feature to connect MySQL directly by using port. only support the server name.

maybe try the ado.net is another way.

kr

Thanks for your reply

I've never worked with ado.net. Can you please point me to some resources or tutorials that describes how to use ado.net in MS-Excel to connect to MySQL.

Thanks

Yesterday's release of Power Query enables this functionality. Simply specify the server as servername:portnumber and it should work.