I generate a ATOMSVC file from Reporting Services and save it to my desktop and when I try
to import into PowerPivot Excel I get the "The remote server returned an error: (401) Forbidden."
error in the Table Import Wizard.
I have the proper authentication information for the datasource (in fact in a previous step of the wizard, the test connection succeeds).
The ATOMSVC file has the proper security information.
The Excel 2010 security is set correctly.
Feed wizard's Advanced Settings have the USER/PASSWORD Information.
Moved byVikram JayaramMicrosoft employeeThursday, June 03, 2010 4:30 PMMoving to the regular SQL forums now that SQL 2008 R2 has RTM'ed. the Beta forums are just for TAP customers and for customers still on CTP3 and RC builds (From:SQL Server 2008 R2 PowerPivot for Excel)