Auteur de questions
I uploaded the powerpivot to sharepoint gallery and tried to do refresh. I have given windows credentials for the refresh.
I configured/installed everything as per the blog http://powerpivotgeek.com/2010/08/18/working-with-the-2010-office-ace-provider/
still it is showing below errors..
06/22/2012 14:49:34.69 w3wp.exe (0x13B8) 0x2608 SSAS Mid-Tier Service Data Refresh 99 High EXCEPTION: Microsoft.AnalysisServices.OperationException: OLE DB or ODBC error: Unspecified error. A connection could not be made to the data source with the DataSourceID of 'a8aca1f4-f683-40ce-ae63-f971c9b8d098', Name of 'Excel NodeAdjustmentValue'. An error occurred while processing the 'Adjustments' table. The operation has been cancelled. at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError) at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact, XmlaWarningCollection warnings) at Microsoft.AnalysisServices.Se...
Toutes les réponses
Find two articles talking about this topic, please check wether it is help to troubleshooting this issue,
TechNet Community Support
I have a source excel file in sharepoint libray. the conenction between powerpivot workbook and source excel is using UNC(webdav).
Though I have all permissions I am getting below error.
OLE DB or ODBC error: The Microsoft Access database engine cannot open or write to the file '\\sharepoint servname\DavWWWRoot\SPowerpivotgallery\excel.xlsx. It is already opened exclusively by another user, or you need permission to view and write its data.; 3051. A connection could not be made to the data source with the DataSourceID of 'a8aca1f4-f683-40ce-ae63-f971c9b8d098', Name of 'Excel. An error occurred while processing the 'Adjustments' table. The operation has been cancelled.
does anybody have luck to fix this? I get the same error and I tried all the mentioned parts. The PowerPivot refresh is working fine for any other data source types (MSSQL, Oracle, DB2, SharePoint lists). I have only issues with the Excel files accessed via DavWWWRoot although the access from server to the file is working fine.