topic Re: Unable to Connect PowerBi Desktop to MySql installed on Raspbery PI - 'DBNull or other types' in Report Server

Unable to Connect PowerBi Desktop to MySql installed on Raspbery PI - 'DBNull or other types'

MustafaOzturk — Sun, 21 Jan 2024 13:29:55 GMT

Hi Community,

I am trying to connect PowerBi Desktop to MySql which is installed on my Raspberry PI but it just does not work. Below are the steps I am doing:

- Select MySql in "Get Data"

- Add Server (In my case, this is 192.168.178.26)

- Add Database (In my case, this is iobroker)

The connection wizard then prompts me to enter Username and Password.

When I click Connect, I get the following message

After clicking ok, I get the following error message.

Does anyone know how to resolve this issue. I did extensive search on the internet but simply cannot find the solution.

Any help is highly appriciated

Thanks

Mustafa

lbendlin — Sun, 21 Jan 2024 18:36:18 GMT

Which MySQL driver version is installed on your PC?

MustafaOzturk — Sun, 21 Jan 2024 18:58:45 GMT

Hi lbendlin , I have installed 'MySQL Connector Net 8.3.0). Hope this is what you are asking.

lbendlin — Sun, 21 Jan 2024 23:09:31 GMT

Downgrade to 8.0.28 or any other "well known good" version.

MustafaOzturk — Sun, 21 Jan 2024 23:41:11 GMT

Tried again with 8.0.28 and 8.0.27. Same issue. By the way, I only need to install this driver on my Laptop right? Not on the Raspberry PI.

lbendlin — Mon, 22 Jan 2024 02:53:23 GMT

yes, only on the laptop.

Do you get the same error when you connect to a MySQL database that is located on a different platform?

Anonymous — Wed, 21 Feb 2024 06:16:54 GMT

MustafaOzturk
i am facing same issue ...
can you got any solution for that error?