cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
braybrookj Regular Visitor
Regular Visitor

Error loading MySQL data with Refresh All

Hey,

 

I changed the connector for my MySQL data from an ODBC to a MySQL connector yesterday. Everything seemed to be ok.

 

Today, I've pressed Refresh to refresh all of the data sources and have the below error:

 

Unnexpecred Error: Container exited unexpectedly with code 0x80004005. Used Features: odbc.datasource/myodbc5a.dll/05.03.0006/MySQL/5.6.10-log,ADOMD.NET/11.0.6020.0

 

However, if I right click on and update each of the tables seperately, all of them successfully refresh.

 

Any ideas why the refresh all doesn't work?

 

Thanks in advance

5 REPLIES 5
Super User
Super User

Re: Error loading MySQL data with Refresh All

Hmm, no that's an interesting one. You could post it in the Issues area.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

braybrookj Regular Visitor
Regular Visitor

Re: Error loading MySQL data with Refresh All

Thanks, I'll give that a try!

Moderator Eric_Zhang
Moderator

Re: Error loading MySQL data with Refresh All

@braybrookj

 

Connecting and refreshing a MySQL data source work fine in my test. Can you try to clean up the data source setting("file"->"options and settings"->"data source settings") and recreate?

 

Also please check you've installed the correct driver.

Capture.PNG

 

braybrookj Regular Visitor
Regular Visitor

Re: Error loading MySQL data with Refresh All

Sorry for the delay.

As mentioned in the OP, the connector works. If I right click on the MySQL tables and refresh individually, there is no issue.

It is only I use Refresh All that the issue occurs.

braybrookj Regular Visitor
Regular Visitor

Re: Error loading MySQL data with Refresh All

I have double checked teh driver and have recreated the tables.

 

Still no joy with the refresh all.

 

EDIT - The error now appears underneath a data source I am pulling in from Analysis Services.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 275 members 2,747 guests
Please welcome our newest community members: