Does anyone faced this issue?
I uploaded powerpivot workbook in Sharepoint 2010 site. All the datarefresh in the site is working fine.
I tried to create a report using report builder 3.0. The datasource I selected is Powerpivot workbook from Sharepoint powerpivot gallery. I am getting the below error
1) The sharepoint site is configured as Kerberos(claims to windows authentication)
2) I checked all the services- all are in start mode
3) I checked the C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\isapi\PowerPivot\web.config
where basicHttpBinding(all 4) is set to "ntlm" - I change to "Windows" and
authenticationScheme to "Negotiate".. but no use, still the same error.
Thanks in Advance
(401) Unauthorized indicates that the connection has been established but the permission check fails.
Check this thread: http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/daf20145-e996-4c93-9450-39bbdbf2c5ab