PowerPivot for SharePoint

PowerPivot is a business intelligence and data analysis tool built as an extension to Excel and SharePoint’s Excel Services. As the business community continues to expand its use of business intelligence tools.
PowerPivot for SharePoint supports Excel 2010/2013 workbooks that contain PowerPivot data and can be publish to a SharePoint site. As a result, other users who do not have the PowerPivot add-in installed can view and interact with the workbook.
In addition, PowerPivot for SharePoint has unique features to extend the capabilities of Excel workbooks that contain PowerPivot data. For example, you can do the following:
  • Highlight workbooks and the information that they contain from within SharePoint.
  • Refresh external connections to resources to keep the data current.
  • Schedule times to update the data automatically.
  • Reuse PowerPivot data from one workbook in other workbooks.
Download PowerPivot for Excel 
How to configure:
PowerPivot workbooks are stored in a special type of SharePoint document library called the PowerPivot Gallery. It is designed specifically for working with PowerPivot workbooks and provides special navigational and preview capabilities for PowerPivot workbooks. The following steps create a new PowerPivot Gallery named Employment Reports.

To create a PowerPivot Gallery

  1. Click Site Action (Gear) and then select Add an App.
  2. Type PowerPivot in the search box, and then select PowerPivot Gallery.
  3. Name the library "PowerPivot Reports" and then click Create.
  4. Add the file to the PowerPivot Reports.


After you create the PowerPivot Gallery, you can modify the settings to your specifications. For example, if you change the library view to anything other than All Documents, you can navigate through workbooks and their respective sheets without having to open the workbook. To experiment with the various PowerPivot Gallery views, follow these steps:

To change the gallery view

  1. Navigate to the Employment Reports gallery.
  2. In the Manage Views section, click the drop-down list under Current View, and then select Theater.
  3. Click the directional areas at the bottom of the page. As you click the arrows, the primary image on the screen reflects an image of a worksheet from a workbook in the Employment Reports gallery. In the bottom-left corner of the screen, SharePoint displays the name of the workbook that is associated with the current worksheet.
  4. Repeat steps 2 & 3 except select the Carousel view instead of the Theater view.
You may get below error when you try to view report in OWA.
This workbook cannot be opened because it is not stored in an Excel Services Application trusted location. To create an Excel Services Application trusted location, contact your system administrator.

This issue is due to that the file is not exist under Trusted location. The following link explained about creation of trusted location.
http://sharepointknowledgebase.blogspot.com/2011/12/excel-services-sharepoint-2010-trusted.html#.VyaFUfkrLIU

When OWA Server view mode is used to view workbooks, the following BI features will not be available.
  • Excel Web Access Web Part
  • Refresh OData connections
  • View and interact with Power View reports
  • View and interact with PowerPivot data models
  • Refresh PowerPivot data models
  • Refresh data by using the Excel Services unattended service account
  • Refresh data by using Effective User Name connections
  • Kerberos delegation

Comments

Post a Comment

Popular posts from this blog

Switch from Classic to Claims Authentication in SharePoint 2010

SharePoint 2013 tutorials, SharePoint 2010 articles, SharePoint interview questions: Switch from Classic to Claims Authentication in Sh... : In this article we will discuss how to switch from Classic Mode Authentication to Claims Authentication. $webApp = Get-SPWebApplication “http://web application URL/” $webApp.UseClaimsAuthentication = 1 $webApp.Update() $webApp.ProvisionGlobally() $webApp.MigrateUsers($True)
Read more

How to query list data using web service

In SharePoint, to query list data we can also use web services provided by SharePoint other than SharePoint API. We can call web services from two places one is JavaScript and another one is .Net client application. Here I will show you both methods. .Net client application To query list data we will use a web service called lists.asmx . 1. Create .net project either windows/console. 2. Add the web reference and the URL looks like http://<servername:portno>/_vti_bin/lists.asmx 3. Give the web reference name as ListsSvc . 3. Add the following code snippet to get list data. ListsSvc. Lists listService = new  ListsSvc. Lists (); // If the current user is having access you can use below code listService.Credentials = CredentialCache .DefaultCredentials; // In case if you want to pass specific user credentials listService.Credentials = new NetworkCredential ( "<username>" , "<password>" , "<domain>" ); string v...
Read more