Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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
Downgrade to 8.0.28
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 56 | |
| 39 | |
| 35 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 73 | |
| 70 | |
| 37 | |
| 35 | |
| 26 |