Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Issues connecting Power BI to a MySQL DB

I'm having a really frustrating time connecting Power BI to a MySQL DB.   Originally I had issues and then followed a post on here where someone identified that it was a MySQL Connector issues. If ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Thanks for your reply.

 

Yeah, I've read lots of different threads on here but none seem to help. I've tried adding and removing 4 different Connetors 8.0.14 to 8.0.17 and none work. 8.0.17 is the only one that gives the error message I mentioned initially.

 

I've got Workbench installed and can connect to the DB fine using that.

I'm definitely using the correct server details and entering details for the Database not Windows.

I've also just managed to get a connection to Tableau working using the same crednetials so I know they are fine.

 

the only thing I can think of is that it is a SSL issue. I initially couldn't connect using Tableau and their Support showed me how to create an SSL folder and an msql file that pointed to the cert location. I don't see a similar way of doing this for Power BI and annoyingly I can seem to find any way to talk to anyone at Microsoft about this.

 

Tom

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Actually as a further update I installed the Connector you linked and removed all other Connectors. Now I get a different error. I assume this means I just need to find the correct Connector version.