Forum Discussion
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...
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.