Using PowerPivot Workbooks from a Mid-Tier Server Configured for Kerberos Authentication
I'm not entirely certain how widely known, but it is quite possible to use a PowerPivot Workbook as a data source for other client applications. For example, both Excel and Reporting Services can use a PowerPivot workbook named AdventureWorks.xlsx that resides on a PowerPivot Mid-Tier server by specifying the data source as something like:
Read more...Tags: sharepoint, security