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