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: http://my_server/powerpivot/AdventureWorks.xlsx….

11