powerbimariadbpowerbi-desktopmysql-connector

Problem with refreshing in PowerBi after updating MariaDB


After an update of MariaDB 10.5.x to 10.11.4 I run into an errormessage when I want to refresh my reports in PowerBi. The message is saying:
--An error occurred while reading data from the provider: Object cannot be converted from DBNull to other types.--

When I use the refresh-button again, the next message says:
--An error occurred while reading data from the provider: The given key is not present in the dictionary.--

(Sorry if the translation isn't exactly correct. I translated from my Dutch-version using Google Translate)

This results in a loop of the same two messages, when I keep trying to refresh.

I tried updating the MySQL Connector from MySQL Connector NET 8.0.28 to 8.2.0 but that didn't help. So I am back to 8.0.28

Is there anyone who has had this happen and resolved the issue?

Our hostingcompany hasn't replied yet to the question to go back to MariaDB 10.5.x but I think that won't be an option: we are running a webshop on this database and the update has been done a couple of days ago, so any backup is already missing lots of orders and information...

11-04-2024: got a new message. This "[ma-3.1.20]Can't connect to server on ..."
This was because of a new IP-adress we got; it needed to be whitelisted, as was our former IP-adress.


Solution

  • Sorry for that trouble. The underlying problem is tracked under https://jira.mariadb.org/browse/MDEV-31608, already fixed, fix will be out in the next release.