Cannot Connect To SharePoint PowerPivot Workbook
Posted on 2013-05-14
I am ready to give up. I have installed PowerPivot on SharePoint and can view PowerView and the PowerPivot (Through Excel Services) just fine. The machine is a single box with SQL Server 2012, Server 2012, and SharePoint 2013 all installed on it. Active Directory is also installed and configured.
When I try and download the .odc file to use the PowerPivot workbook as a datasource, I get an error after I click "enable" in Excel. THe error I keep getting is:
"Unable to connect to datasource. Reason: Access Denied. You either made a mistake typing in your User ID, and/or password, or you do not have permission to access the database server."
I never enter my credentials, and I am the administrator of this test machine. What do I need to do before I go out of my mind?