Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |