cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DIMBACKA
Regular Visitor

Power BI Desktop MySQL connector

Hi all,

I'm trying tot establish a connection to a MySQL database. Both PBI and MySQL are installed on the local machine.

Upon connection to the database, I get an error mentioning a missing system variable named 'lower_case_table_names'.

Research points me towards the MySQL version.

I still have to use an outdated MySQL instance due to software incompatibility.

 

Can someone please share ideas on how to connect to a MySQL version 5.0?

4 REPLIES 4
lbendlin
Super User III
Super User III

here's an intriguing workaround

 

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

 

I couldn't find any point about the minimum version but I would think that the MySQL Community Installer (currently version 8.0.21) would allow you to connect to your legacy database as well?

Hi Ibendlin,


Thanks for your reply.
I'll give the SQL Native Client a try.

 

What I can confirm, is that the MySQL Community Installer 8.0.21 is not working at all.

I've tried several versions, not one is working.

I've analyzed the returned error message using WireShark, and I was able to get some more information.
Apparently, at some point, MySQL has altered their routine to authenticate against the database, which is causing this connection to fail. My guess is that the MySQL Community Installers only use the new method, and the old authentication method (as used by MySQL 5.0 and below) is ignored.

Good afternoon DIMBACKA.

I hope you are well.

 

Did you manage to connect your data in the end?

I am also facing the same error mentioning a missing system variable named 'lower_case_table_names'. (MySQL V5.0 User as well)

Hi LukeJWest24,
Unfortunately not, at least not with a direct connection.
I ended up using an ODBC connection, which eventually gets the data into Power BI, but I must say this is not the ideal situation.

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors