We cannot locate a server to load the workbook data model
Issue-The Error was coming in SharePoint 2013 site
when refreshing or clicking on any slicer of the Power table Report in excel 2013 workbook.
Issue Cause-This issue occurs because the
Analysis Services instance has not been configured in the Central
Administration site.
Issue Solutions-Restart your SQL Server
Analysis Server (PowerPivot) and Reset the IIS.
In most of the case above will fix your above Issue.
If in case the above method will not fix the Issue then configure the Excel Services service application on
the SharePoint server. To do this, follow these steps:
1.
In the Application Management section
of the Central Administration home page, click Manage service
applications.
2.
On the Manage Service Applications page, click the Excel Services
service application that you want to configure.
3.
On the Manage Excel Services page, click Data Model.
4.
Click Add Server.
5.
In the Server Name box, type the name of the Analysis
Services instance that you want to add.
6.
Click OK.
My SQL is Standard edition and SharePoint is Enterprise edition. Will Power Pivot work in my environment ?? Do I need to take any license for Power Pivot ?
ReplyDeleteNo it will not work, Your sql should also be in Enterprise Edition
Delete
ReplyDeleteThanks for sharing valuable information. Your blogs were helpful to tableau learners. I
request to update the blog through step-by-step. Also, find the tableau news at
Tableau Online Training Blog.
Wow this is amazing, you can also learn how to use tableau with the help of tableau online training
ReplyDeleteNew web site is looking good. Thanks for the great effort. Data Blending in Tableau
ReplyDeleteYou make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. https://serverbrowse.com/
ReplyDeleteThat is really nice to hear. thank you for the update and good luck. data entry bpo solutions
ReplyDelete