Using SharePoint List
Data in PowerPivot
Read the article “http://www.microsofttechnology.net/2013/12/step-by-steps-installing-powerpivot-for.html”
first before read this article
Open your site and input data into your Tasks list
Open http://pc-0273:8080/_vti_bin/ListData.svc/Tasks
and copy it. You also get the other list by using http://<sharePointsiteName>/_vti_bin/ListData.svc/<ListName>.
Open excel and click to the PowerPivot Tab >>
PowerPivot Window
On PowerPivot Window >> click to From Data Feeds
Ribbon
Paste this link to Data Feed Url then click Next
Click Finish
Click Close
Data is imported
Click to PivotTable Ribbon >> choose PivotChart
Using Existing sheet then choose 2 columns Title and
Complete as follows:
Save it and named is Book3. Upload it to PowerPivot Gallary
Click to Manage Data Refresh of Book3 >> Configure
Schedule ...
Update data in Tasks list
Waiting 12:15PM data is refreshed
Check your Schedule
