none
POWERPIVOT IMPORT FAIL RRS feed

  • Question

  • I am trying to import data  from a MySQL database using ODBC (I have the latest driver) and I receive the error message below when using PowerPivot. However the connection and import work perfectly when importing to Excel without using PowerPivot. All in Excel 2010. Would be grateful for any advice. many thanks.

    "OLE DB or ODBC error. The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. An error occurred while the partition, with the ID of 'MS_9d5fe549-6477-43a2-b282-74970df34317', Name of 'sessions' was being processed. The operation has been cancelled."

     

    Thursday, May 6, 2010 11:08 AM

Answers

  • Hi there,

    The error unfortunately gives us very little to go on.  How large is the sessions table?  Can you connect with ODBC Test and run a SELECT * query to retrieve all the rows?  You can get that tool from here:  ftp://ddtools:ddtools@ftp.datadirect.com/outgoing/tools/odbctest.zip  In that tool, click the Full Connect button on the toolbar (looks like hands shaking) to connect to your database, then type the query SELECT COUNT(*) FROM Sessions (or if this is not the table name, substitute the actual table name).  That shoudl tell us how many rows to expect.  If it is not excessively large, you can try SELECT * FROM Sessions of course.  If this is returned from ODBC Test, we may need to investigate further, but first let's try this to confirm connectivity and that the data is returned from ODBC.

    Jon

    Thursday, May 6, 2010 9:15 PM

All replies

  • Our engineers have been a bit busy offlate, but we'll find someone to respond to this. Thanks!
    Thursday, May 6, 2010 8:10 PM
    Moderator
  • Hi there,

    The error unfortunately gives us very little to go on.  How large is the sessions table?  Can you connect with ODBC Test and run a SELECT * query to retrieve all the rows?  You can get that tool from here:  ftp://ddtools:ddtools@ftp.datadirect.com/outgoing/tools/odbctest.zip  In that tool, click the Full Connect button on the toolbar (looks like hands shaking) to connect to your database, then type the query SELECT COUNT(*) FROM Sessions (or if this is not the table name, substitute the actual table name).  That shoudl tell us how many rows to expect.  If it is not excessively large, you can try SELECT * FROM Sessions of course.  If this is returned from ODBC Test, we may need to investigate further, but first let's try this to confirm connectivity and that the data is returned from ODBC.

    Jon

    Thursday, May 6, 2010 9:15 PM