PowerShell Scheduled Data Refresh – Call to Excel Services Returned an error

In SharePoint Power Pivot data Automatic refresh from excel services, I got an error saying that “Power Pivot Scheduled Data Refresh – Call to Excel Services Returned an error” as shown the image below

By digging into the issue I have found that I don’t have permissions for Power Pivot service. To fix the issue we have to add the permissions for Power Pivot. To add we need to give the account running Power Pivot Full Control to the Web app under the Policy for Web Application.

Hope this helps.

SharePoint Power view error: There are no addresses are available for this application

Working with SharePoint power view I got an error saying that “Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application.”

Checking the error I have found that we have to run SQL Server Reporting service, Manage metadata service and user profile services. We have to make sure that they are running properly. To do that navigate to SharePoint Central Administration, Application Management section. Click on Manage Services

Check for SQL Server Reporting service, Managed meta data service and User profile services are started or not. If not started Start the services. Reset IIS manager (IISRESET)