Hello Everybody,
Last week I studied about how to configure, get it working and test the PowerPivot on SharePoint 2013.
The best tutorial I found was at the link http://technet.microsoft.com/en-us/library/dn456880(v=office.15).aspx
I have downloaded and published the video directly here: https://www.youtube.com/watch?v=n9Qsxl3GZYk
On this post I added some configurations that not are included in this video:
1) Excel Services Configuration:
1.1 I have created an Site Collection called “BICenter” within my web application http://portal.mabotega.local. The complete URL was http://portal.mabotega.local/sites/BICenter;
1.2 I added the BICenter Document Library (in my scenario: http://portal.mabotega.local/sites/BICenter/Documents) on the “Trusted File Locations” on the Excel Services Application configuration. For to do it, click on the “Manage Application Services” within “Application Management” section:
1.3 Click on “Excel Service Application”
1.4 Click on the “Trusted File location” link:
1.5 Add the Document Library address at the “Address’ field: http://portal.mabotega.local/sites/BICenter and Check the “Children Trusted”, and confirm in “Ok” button:
The result will be like this:
2) PowerPivot Permisions:
2.1 Run the PowerShell below changing for the appropriated values for your environment:
In my scenario I have used the URL: http://portal.mabotega.local
$w = Get-SPWebApplication -identity http://portal.mabotega.local
#this is the application pool account that runs the PowerPivot Service Application in my scenario
$w.GrantAccessToProcessIdentity(“MABOTEGA\RBTSHPSR10″)
2.2 Be sure if the command worked well:
Open the SQL Server Management Studio;
Expand Security –> Logins;
Double click on your PowerPivot application pool account (in my scenario MABOTEGA\RBTSHPSR10);
Select User Mapping;
In the “User mapped to this login” session, select the content database for your application. In my scenario http://portal.mabotega.local, content database DBSPS_Portal_Content;
In the “Database role membership for: DBSPS_Portal_Content” session, make sure that the “SPDataAccess” role is selected:
3) Secure Store Service Application
3.1 Select your “Secure Store Service Application” and set the appropriated Unattended user account to be used by Excel Service to get information on PowerPivot. In my scenario MABOTEGA\RBTSHPSR11. The Owner of this credential is the user account that will run the PowerPivot Application Pool, in my scenario MABOTEGA\RBTSHPSR10:
3.2 Open the SQL Server Management Studio;
Expand Security –> Logins;
Double click on your U accounattended account (in my scenario MABOTEGA\RBTSHPSR11);
Select User Mapping;
In the “User mapped to this login” session, select the content database that is get information. In my scenario I have followed the sample in the Microsoft video and I called the “Cities”. In the “Database role membership for: Cities” session, make sure that the “db_datareader” role is selected:
That’s it for now!
No comments:
Post a Comment