What is PowerPivot for SharePoint? Part 2.

Now that we have a PowerPivot workbook in the Excel Rich Client, we are ready to publish that workbook to SharePoint. In “What is Power Pivot for SharePoint? Part 1” I discussed the Data Model and how it is a database inside of Excel.  When you publish/upload a regular Excel workbook to SharePoint, that file gets chunked up…

6

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

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…

9