Tuesday, April 16, 2013

We cannot locate a server to load the workbook Data Model

Problem Description:

After install power pivot on your server, when you try to either refresh the PivotTable or filter the data in the PivotTable, you may get the following error message:

“We cannot locate a server to load the workbook Data Model.”

Reason of issue:

This issue occurs because the server instance has not been configured in the Central Administration site.


1.    To work around this issue, configure the Excel Services service application on the SharePoint server. To do this, follow these steps:
2.    In the Application Management section of the Central Administration home page, click Manage service applications.
3.    On the Manage Service Applications page, click the Excel Services service application that you want to configure.
4.    On the Manage Excel Services page, click Data Model.
5.    Click Add Server.
6.    In the Server Name box, type the name of the analysis Services instance that you want to add.
7.    Click Ok.

If you have a query/ help, Please mail me or write it on comment bo.

Tuesday, April 2, 2013

Limitation of office 365

Limitation of office 365 

There is a lot of discussion is going around sharepoint developer world about office 365. How it is good for small or medium business company, what are advantage and disadvantage? And what are the limitations, etc. Actually I don’t want to cover all the discussion in the single article. But, I would like to notify the people who wants to use the office 365 in their company that the office 365 limitation, this is not meaning of disadvantage of office 365.
             1)      Custom Web part
             2)      List threshold
             3)       Site collection under one web application umbrella
             4)      Web analytics customizing
             5)      Power pivot Support
             6)      Reporting service
             7)      BCS
             8)      Fast search
             9)      Migrating to office 365