a workbook with powerpivot data with embedded data connection is published to our sharepoint site. The workbook is set up with a unattended refresh account and the data is refreshed every night. This works ok. But the problem is this:
After the workbook is refreshed, if a user with "View only" permissions access it first then this error occures and the user can't oen the workbook:
Cannot open this workbook because it contains external data that could not be refreshed. You may not have permission to use the data connections, or the data connections may not be responding to the refresh operation.
If a user with Read permission (or contribute or full access) open the workbookfirst then the workbook is opened ok. AND the user with View only access can access it afterwards also. The problem is only if the View only user opens it first after refresh.
Any ideas how this can be fixed?