Forum Discussion
Unable to connect POWER BI to MySQL DB
Hi,
I am unable to connect Mysql DB with Power BI, we have already installed Mysql connector and Mysql Workbench but still not connecting. Is there anyway to resolve this issue?
Thanks,
Maneesha
Hi Anonymous ,
As far as I know, Power BI support us to connect to MySQL directly by MySQL database connector directly.
Please you have install MySQL correctly in your local.
You may need to check whether the server name, the database name and the password you use is correct.
For reference:
Power Query MySQL database connector - Power Query | Microsoft Learn
How to connect power bi with mysql server and import data - Bing video
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
As far as I know, Power BI support us to connect to MySQL directly by MySQL database connector directly.
Please you have install MySQL correctly in your local.
You may need to check whether the server name, the database name and the password you use is correct.
For reference:
Power Query MySQL database connector - Power Query | Microsoft Learn
How to connect power bi with mysql server and import data - Bing video
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Greg_Deckler
Community Champion
Anonymous I think I've only ever gotten this to work using DB credentials. Is that what you are using?
