Reading MSDN, we stumble on the following page and read:

PowerPivot Authentication and Authorization (msdn.microsoft.com/en-us/library/48230cc0-4037-4f99-8360-dadf4bc169bd)

PowerPivot converts a claims token that it gets from Excel Services to a Windows user identity. Any web application that uses Excel Services as a resource must be configured to use the Windows authentication provider.

I do not know if the article is still valid in SharePoint 2013 or just 2010. Now, in our SharePoint Server 2013 environment we have configured Claims Based Authentication with AdFS 2.0. Said AdFS is configured to only have users from one source - mainly Active Directory. My question is, will Excel Services work with our configuration? Can anyone point me to any help regarding how to configure such a scenario properly?

Thank you for reading my question

Rafal Saltarski

In SharePoint 2013, PowerPivot supports Windows Claims only, it does not support SAML (ADFS).

http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/MSFTBIAuthOverview.docx

Hi Trevor,

thank you for your answer. This begs another question though, which is how exactly is PowerPivot working on Office365?