Mysql Connection

[Upali63]

Hi Friends.

I am new to power bi. I am using Power BI desktop version. I want to connect to my cliets external server to extarct data to my power bi app. But I am unable to it in fact I have no idea how to do it. Kindly help with step by step illustartion of how to do it

[Upali63]

I get the above massege pls

[v-zhangti]

Hi, @Upali63 

For a tutorial on connecting Power BI to Mysql you can refer to the following link.

https://help.scalegrid.io/docs/connect-mysql-to-powerbi 

https://docs.microsoft.com/en-us/power-query/connectors/mysqldatabase 

Regarding the error you are getting, please refer to the following link, hope it helps.

https://community.powerbi.com/t5/Desktop/Cannot-Connect-to-MySQL-Database/m-p/275947 

Solved: MySQL: Unable to connect to any of the specified M... - Microsoft Power BI Community

Solved: unable to connect to mysql - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

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

[amitchandak]

@Upali63 ,

Refer if these can help

https://blog.panoply.io/powerbi-mysql-challenges-and-alternatives

https://www.youtube.com/watch?v=4DQSEI4GlY8