Excel Services & PowerPivot for SharePoint

Troubleshooting Excel Services and PowerPivot for SharePoint rendering and refreshing in the browser.

PowerPivot for SharePoint - Schedule Data Refresh Error: "A schedule cannot be enabled for a workbook with no external data sources."

PowerPivot for SharePoint - Schedule Data Refresh Error: "A schedule cannot be enabled for a workbook with no external data sources."

  • Comments 3
  • Likes

If you come across this error when trying to perform a scheduled data refresh:

"A schedule cannot be enabled for a workbook with no external data sources."

This is because the Data Model cannot be created on the PowerPivot Server.

Your probably have two questions.

1. What is a "Data Model".

The Data Model is a cube created under the PowerPivotServer\POWERPIVOT instance:

2.Why can't/isn't the Data Model being created?

The reason why this isn't being created is because there is something wrong with the Excel Services "Data Model Settings".

You can find this be going to the Central Administration > Application Management > Manage Service Applications > Excel Services > Data Model Settings.

At this location, you need to enter the proper PowerPivotServer\Instance

Here is the proper way:

Here is a bad example (no need to have just the server name present):

Here is another bad example (PowerPivot) is misspelled:

I hope this helps.

Tom

 

 

 

Comments
  • an other reason which could cause this problem, Check if the SQL Server Analysis services are running on server where PowerPivot is configured. If not start the service.

  • is this option is only in SP 2013? I am not finding in SP 2010

  • pankaj: This option is only available in SharePoint 2013 as there is no PowerPivot Analysis Services dependency on SharePoint. In SharePoint 2010, PowerPivot Analysis Services must be installed on a SharePoint server, so the SharePoint farm is already aware of the instance.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment