The refresh operation failed for PowerPivot on SharePoint 2010

April 11, 2013

Yes I know. I can hardly believe it myself. I’m here again. And I’m glad to be back. Soโ€ฆ to business!
We wanted to create reports on an excel file our user was updating. We loaded the data into PowerPivot, published the Excel 2010 file into a SharePoint 2010 library and then created Panorama Flash views on top of that (and that’s me making a very long story short!).

The daily Excel data update worked fine untilโ€ฆ one day it didn’t. Obviously it’s just a few days before a presentation to our head of department ๐Ÿ™‚
My colleague Tomer Horev, who’s in charge of the SharePoint end, was trying to find a reason for the connection failure. The error message was:


 


The refresh operation failed because the source data base or the table does not exist, or because you do not have access to the source



More Details:



OLE DB or ODBC error: Unexpected error from external database driver ().; 3275.



A connection could not be made to the data source with the DataSourceID of ‘f3b6242a-ff67-4e84-8f20-847861d6e7ab’, Name of ‘Excel XYZ’.



An error occurred while processing the ‘DATA’ table.



The current operation was cancelled because another operation in the transaction failed.



Out of line object ‘DataSourceView’, referring to ID(s) ‘Temp_DSV’, has been specified but has not been used.


 




A link for Unexpected error from external database driver helped him understand that he needed to add Imex=1 in the connection string.


Just look under the Design tab for Existing Connections > choose the relevant connection > click the Edit button and then the Advanced button:


 


The Refresh Operatrion Failed 1


 


 


The Refresh Operatrion Failed 2


 


 


So, a failed data refresh for an Excel 2010 on SharePoint 2010 can sometimes be a broken PowerPivot connection.


 


Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*