asked on
Cannot Connect To SharePoint PowerPivot Workbook
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?
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?
Microsoft SharePointMicrosoft ExcelMicrosoft SQL Server
Last Comment
colly92002
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.