topic Re: Excel file schedule refresh problem in Report Server

Excel file schedule refresh problem

obesli — Tue, 08 May 2018 09:35:25 GMT

I have an excel file on sharepoint to use in reports. When I want to scheduling I got this type of error. What can I do for this error?

Re: Excel file schedule refresh problem

Anonymous — Wed, 09 May 2018 12:41:50 GMT

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).

Re: Excel file schedule refresh problem

obesli — Thu, 10 May 2018 11:43:17 GMT

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."

Re: Excel file schedule refresh problem

Anonymous — Thu, 10 May 2018 11:48:40 GMT

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?

Re: Excel file schedule refresh problem

obesli — Thu, 10 May 2018 12:36:45 GMT

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.