SQL DB connection issue (MySQL/MariaDB)

[Tamas_Praviczki]

Hi everyone!

I would like to connect to a MySQL DB but I cannot. I tried it as MySQL and MariaDB as well.

Power BI version: 2.122.746.0 64-bit (2023. october)

MySQL connector-net version: 8.1.0 (latest)

MariaDB connector-odbc version: 3.1.19-win64 (latest)

If I try to connect as MySQL DB, the answer will be this one:

As a matter of fact, I tried it with older version as well (8.0.28), but in the end the answer was there is an issue with nulls or something like that. 

If I try to connect as MariaDB, the answer will be this one in the Power Query: 

I know the problem is null values, but how can I deal with it? MySQL would be better because I could run a query before loading. 

Thanks for any advice!

Kind regards,

Tamas Praviczki 

[lbendlin]

Downgrade to 8.0.28

[Tamas_Praviczki]

It doesn't work. I tried it and it couldn't deal with nulls. I mean Power BI doesn't connect to DB. However, with HeidiSQL I can read the table without any issue and it contains nulls.