Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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.
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.
Hmm, no that's an interesting one. You could post it in the Issues area.
Thanks, I'll give that a try!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |