power bi desktop can not connect azure mysql

[xiaoyi_yang]

when i try to connect to azure mysql instance , i get this error message.

please help to advise. below is error message

[xiaoyi_yang · Accepted solution]

Hi, i found the root cause, i connect to mysql with mysql connect/net 8.0.25, this version of connector has a connect issue. when upgrade connector to 8.0.28, this issue solved.

[amitchandak]

@xiaoyi_yang , make sure ips are whitelsited

refer

https://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-with-powerbi-desktop

[xiaoyi_yang]

hi, Amittchandak

 thank you for your answer. i check with my network team, i think mysql domain address is in whitelist .i can connect to mysql with mysql workbench, i'm not sure is it ok about the ips access issue.