Unable to connect to datasource(Powerpivot workbook in Sharepoint gallery) using report builder 3.0

Question

Hi All,

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

Note: 

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

Answer 1

(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