Connect Power BI with XAMPP Apache without installing the XAMPP

[Karthik12]

Hello Folks,

Our factory production line output monitoring system working in MYSql and develped in XAMPP apache phpmyadmin. it possible to connect my Power BI to MySQL without installing the MYSql workbench or XAMPP Apache in my laptop?

If Yes, can you know what are the things to do?

Thanks in advance

Have a nice time !!

[lbendlin · Accepted solution]

All you need is the MySQL .Net driver 8.0.28 . (Don't install 8.0.29 , it has a bug)  No need for Workbench, Community installer or any other components.

[Anonymous · Accepted solution]

Hi @Karthik12 ,

Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).

After installing the MySQL connector, refer to this blog to connect to MySQL in Power BI Desktop.

If the connection still fails in Power BI Desktop, please check that if you are able to connect to the MySQL database in MySQL workbench, ensure that MySQL workbench is installed in the same machine as Power BI Desktop.

Best Regards,

Jay

[Karthik12 · Accepted solution]

Hi @Anonymous I can able to connect successfully after lot of troubles. Finally, I followed below steps and succeeded.

Hope you trying to connect same Xampp running in your organization's server.

Please follow these Steps :

1. Install MySQL connector in you PC 8.0.28

2. Give full privilleges in to your ID in Xampp application. (It can be done either by you by taking that server in remote connection if you have server access or IT admin)

3. Get data --> MySQL database 

Enter IP address of the server and database name

4. Import required tables into Power Bi

That's all. If error or doubt, please revert.

[Anonymous]

Hi Karthik,

Thanks for the quick response.Yes, we are trying to connect same Xampp running in our organization's server.

I have tried and getting the Encryption Error.

Also ,I have doubt regarding the Step 2 which user (Database user like root or Windows user).

Thanks,

Priya

[Karthik12]

Hi @Anonymous  Hi, please press OK, it will through.

or uncheck the below option in file ->Options and setting --> datasource setting --> select current source -->edit --> uncheck

[Anonymous]

Thanks a lot @Karthik12 Was able to connect after they have provided me the Full privileges.

Appreciate your help!

[Karthik12]

Thanks @Anonymous 

Please accept these steps as a solution and provide kudos so that others can easily reach this solution for their queries. 

[Anonymous]

Hi @Karthik12 ,

I Tried to mark as Solution ,But this Query already has one solution .Due to which,I am not getting the option "Mark As Solution".

Thanks,

Priya

[lbendlin]

I marked it as a solution.  8.0.28 is safe (it avoids the bug in 8.0.29)  but in the meantime MySQL have rolled out new drivers that also seem to work.

[Anonymous · Accepted solution]

Hi @Karthik12 ,

Before you can connect to a MySQL database, you need to install MySQL Connector/Net 6.6.5 for Microsoft Windows on your computer. Select the driver that matches your Power BI Desktop installation (32-bit or 64-bit).

After installing the MySQL connector, refer to this blog to connect to MySQL in Power BI Desktop.

If the connection still fails in Power BI Desktop, please check that if you are able to connect to the MySQL database in MySQL workbench, ensure that MySQL workbench is installed in the same machine as Power BI Desktop.

Best Regards,

Jay

[lbendlin · Accepted solution]

All you need is the MySQL .Net driver 8.0.28 . (Don't install 8.0.29 , it has a bug)  No need for Workbench, Community installer or any other components.

[Karthik12]

Hi,

Thanks for your time to guide me. Yeah, I have installed above said connector and tried again.

It is asking server and data base. I have entered that too as per given data base from IT admin.

But, it shows an error

"Details: "An error happened while reading data from the provider: 'One or more errors occurred.'"

I have attached a screenshot of it too.

To solve this, Do I have make necessary changes in Xampp to allow any remote connection ?

or, anything else?

Thanks in advance for the support !

[Anonymous]

Hi @Karthik12 ,

Where you able to connect,Because i am also going through the same.

Thanks,

Priya