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
Administrator
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
    Super User
    2 years ago

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