Power Query connect to SQL db not working with correct details!

[daleholden]

HI Guys
I have fully followed MS help page and Mike Girvins on how to connect to a SQL db.
I have tried to connect to my Magento 2 SQL db which i can do with a script no issue.
But when i go through with Excel 365 i get an error see here this the error popup
Any ideas why it is not working?

 

[Matt Allington]

Your post says you are using “Magento 2 SQL” but the error refers to a Microsoft SQL DB. Are you trying to connect to a Magento 2 SQL using a Microsoft SQL connector? That will not work. If there isn’t a Magento 2 SQL connector, you will need to use odbc.

 

[daleholden]

Your post says you are using “Magento 2 SQL” but the error refers to a Microsoft SQL DB. Are you trying to connect to a Magento 2 SQL using a Microsoft SQL connector? That will not work. If there isn’t a Magento 2 SQL connector, you will need to use odbc.

HI Matt
Yes silly me i was trying SQL but my DB's was MYSQL so now i got it fixed.