Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Edouard1mushame
New Member

How can i connect Power BI to an hosted MySQL databse server

I am trying to connect Ppower BI to my hosted MySQL database server, this is hosted on LWS (cpanel), i put the server address, the username, the password and the port number(3306), but i am getting the error attached.

Edouard1mushame_0-1707309655582.png

Is there someone to help me how can i resolve it.

Thanks a lot for your support

1 ACCEPTED SOLUTION
M_nwadibia
Resolver III
Resolver III

I think you need to install MySQL database server drivers on the server where you have Power BI hosted. 

I experienced this in the past with Oracle SQL. I installed Oracle Database driver on the Report server DB host server and it solved my problem

View solution in original post

1 REPLY 1
M_nwadibia
Resolver III
Resolver III

I think you need to install MySQL database server drivers on the server where you have Power BI hosted. 

I experienced this in the past with Oracle SQL. I installed Oracle Database driver on the Report server DB host server and it solved my problem

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors