Sign up for Office 365
Learn more about Office 365
I have found this White Paper on “Using SharePoint List Data in PowerPivot” but it is mentioned that if you are using Microsoft Office 365, you cannot access list data in the Atom format. This is a current limitation.” It is however possible to access the list data in Atom format using this URL http://<sharePointsiteName>/_vti_bin/ListData.svc/<ListName>. I have done this with success in the browser but if I try to use Power Pivot connect to the data source as described in the guide I get an “The remote server returned an error: (403) Forbidden..”
Is it possible to enable the Power Pivot in SharePoint Online? Does it require an specific plan to enable this? Or is there another way to achive the functionally that excel provices(aggregating list data).
It is not possible to use the Graph webpart since I need to aggregate the data in the list.
I'm looking into this for you to see if it's possible. As soon as I am able to get an answer, I'll reach out to you to let you know the outcome and the why's and why-nots.
I'm still looking into this, but in the meantime, I wanted to share our Developer Guide with you to see if it could point you in the direction you need to go.
Hi John, thank you for your replies.
I have found a workaround for now as the current requirements from the customer allowed a simpler solution. We basically needed a graph based on aggregated data from a sharepoint list.
I have written a blog entry here.
I have from the customer been told that PowerPivot in SharePoint Online is currently not available and that it was during the beta it was possible to use this feature. It would be nice to know when it will be possible to use this in SharePoint Online and also from which plans it can be used as it will allow for more advanced graphs and easier for the customer to adjust.
You're very welcome! I'm glad that you were able to find a solution to work around PowerPivot currently being unavailable for SharePoint Online.
At the moment, I don't have a timeline as to when this feature will be re-enabled, though.