Powerpivot 2010 use sharepoint list as a source and autorefresh

[janathan]

Could you help me resolve an issue with something similar. I connected an excel spreadsheet which resides on the BI server to a data model also on the Bi server. It refreshes fine if I pull the data model down to our machine but fails when I try to setup auto refreshes on the server. Here is the error message.OLE DB or ODBC error: Failure creating file.; 3436. A connection could not be made to the data source with the DataSourceID of ’73e87f62-05ac-4ed3-bf5f-8152ef3c82c2′, Name of ‘Excel ATT2014TABLES’. An error occurred while the partition, with the ID of ‘BMS Only_ee478831-c49e-4d64-8525-14bb2e3cfb6a’, Name of ‘BMS Only’ was being processed. The current operation was cancelled because another operation in the transaction failed.I tried what you have in the article above but the connection string was exactly the same,Any help you can provide will be appreciated.

 

[scottsen]

I think a sharepoint admin is going to have to slog through ULS (sharepoint logs) in hopes of finding more error info