PowerPivot and Claims Based Authentication-Is there hope in SQL 2012?
As many of us have painfully found, PowerPivot v1 on a Claims Based Authentication web application is not supported in SharePoint 2010. I had a case open with Microsoft last year that had the aspirations of rectifying that situation. We had hoped that working with the PowerPivot team (a part of the SQL Server Product team) and the SharePoint Product team that we would be able to find a way for Microsoft to change their stance and provide us a way to allow PowerPivot v1 to be supported.
Read more...Tags: sharepoint