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

Question

Hi Community,&nbsp;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:&nbsp;- Select MySql in "Get Data"- Add Server (In my case, this is 192.168.178.26)- Add Database (In my case, this is iobroker)&nbsp;The connection wizard then prompts me to enter Username and Password.&nbsp;&nbsp;&nbsp;When I click Connect, I get the following message&nbsp;&nbsp;After clicking ok, I get the following error message.&nbsp;&nbsp;Does anyone know how to resolve this issue. I did extensive search on the internet but simply cannot find the solution.&nbsp;Any help is highly appriciatedThanksMustafa&nbsp;&nbsp;

lbendlin · Answer

Which MySQL driver version is installed on your PC?

mustafaozturk · Answer

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

lbendlin · Answer

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

mustafaozturk · Answer

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 · Answer

yes, only on the laptop.
&nbsp;
Do you get the same error when you connect to a MySQL database that is located on a different platform?

Forum Discussion

Related content

Tesseract install

Power BI - Data Gateway Installation Issue

Oracle Connection error 'Oracle.DataAcess.Client' Not Installed

Power BI Gateway Installation issues

Connection failed using a Folder connection in a pipeline