0

I am having the same issue. I tried everything above as well as what was suggested here:

http://blog.qumsieh.ca/2013/08/19/ssas-sharepoint-2013-we-cannot-locate-a-server-to-load-the-workbook-data-model/

I also rebooted the server but still the same error.

  • I'm unable to read anything on that site.Could you please include more detail here? Detailed error messages, details about what you have tried, etc – Robert Kaucher Mar 28 '14 at 3:00
  • I am receiving the following error when attempting to load a PowerPivot workbook in the browser "We cannot locate a server to load the workbook data model. It is the same issue this user is experiencing: sharepoint.stackexchange.com/questions/76383/… – KellyS Mar 28 '14 at 13:56
  • I have verified that I do have the Analysis Services server configured correctly in Central Admin and that the service account has admin privileges on the server. I can connect to the Analysis Services instance through SSMS as well. Here is what I am getting in the ULS logs: Failed to create an external connection or execute a query. Provider message: There are no servers available or actively being initialized., ConnectionName: , Workbook: shrptd-v/sites/bi/Datawarehouse%20Monthly%20Reports/…. – KellyS Mar 28 '14 at 15:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.