Forum Discussion
Excel file schedule refresh problem
Is your connection string using a mapped drive letter (e.g. W:\MyFile.xlsx)?
If so this won't work, you'll need to use a UNC path (e.g. \\MyServer\MyFile.xlsx).
Your proposal works well, dataconnection section test connections are all ok. But when I want to refresh the data in the scheduled refresh section then I got this error.
Do you have any idea about this?
"Credentials are required to connect to the SharePoint source. (Source at http://intranet.). The exception was raised by the IDbCommand interface."
Glad you got over the first issue.
The error you're now seeing looks like a permissions issue. Can you confirm the credentials you are using to read the Excel file have the correct permissions assigned?
Actually I tried a lot of time for refreshing, but everytime I got this error. My report uses bot the excel file and sharepoint lists. The error message is related to the sharepoint lists. Sometimes I got the same error for the excel file.
The excel file have no login need to connect, but authentication for the file folder is given in the authentication part as Windows account.