Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
Show and Tell
Tips and Tricks
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Hello dears,

Has anyone had any luck fixing the 'lower_case_table_names' system variable problem?

I was connecting to the database without problems for almost 2 years, and suddenly I started having this problem.

I've tried several versions of the .NET connector but can't find the solution.

We look forward to your comments.

Thank you very much in advance.

Gaston

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

8.0.28 is a known good version. 8.0.30 and 8.0.31 might work as well.