cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rem_time
Frequent Visitor

Couldn't connect to MySQL database data source issue to schedule refresh

Hi everyone, 

 

We're trying to schedule a refresh of our dashboards but we couldn't get through the MySQL data source. The MySQL database that we've connected to is from one of our supplier while our company is using SQL Server. We have successfully tested the connection to the SQL Server source but we're just having error with the MySQL data source (as pictured below). 

 

We have installed the Connector Net v. 28 and also made sure that the credentials we are using are correct. Can you please point out what are we missing here?

 

rem_time_0-1657684233015.png 

rem_time_1-1657684513024.png

 

Thank you in advance guys! 🙂

 

 

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @rem_time ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

v-luwang-msft
Community Support
Community Support

Hi @rem_time ,

Try to download and installed the latest version of client software,and remember to download  64 bit connector.

download link:

https://dev.mysql.com/downloads/mysql/ 

 

Similar error refer:

https://community.powerbi.com/t5/Power-Query/Power-BI-Desktop-Unable-to-Connect/td-p/8606 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.