SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL
SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL

PowerPivot

VIDEO – Tour of SSRS, PowerPivot, and PowerView

I wanted to record an introduction to the new reporting and Business Intelligence capability within SharePoint 2013.   After loading SP2013, there are a few steps to activate the backend Service Applications for BI.   The SQL 2012 install media is needed for this to install SSRS Integrated Mode and PowerPivot.

However, once those are online you can load great samples like “PowerView – Hello World Picnic” to browse real data and confirm it all works correctly.   Very cool stuff, enjoy!  

Smile

References

 

SSRS-PowerPivot-PowerView from Jeff Jones on Vimeo.

PowerShell: Get today’s date only

Recently I needed to get a [System.DateTime] object with today’s date only (no time information).   Sounds easy, right?

At first I found “Get-Date -displayhint date” on http://technet.microsoft.com/en-us/library/ee176845.aspx     While the output looks nice, it only affects console string display.  The underlying object still has full timestamp information.

I ended up coding “New-Object "System.DateTime" -ArgumentList (Get-Date).Year, (Get-Date).Month, (Get-Date).Day” as the clean way to create a new object with today’s date only.   This allowed the rest of my code to then work perfectly.  Hope this helps somebody else too! 

Smile

 

FIXED – Rule “User account requirement for Farm administrator” failed

When installing PowerPivot on SharePoint 2010 you might see the below error.   Behind the scenes several permissions are being verified, not just Farm Admin.   In my case I also needed to grant SQL SYSADMIN permission to the user account performing the install.  This error message is confusing because it can occur even if you are listed on Central Administration as a Farm Admin.  So before you run “setup.exe” on the SQL CD, be sure to double check your permissions.

 

PowerPivot install account needs:

  • Local Administrator 
  • Farm Administrator 
  • SQL sysadmin fixed role 

Rule "User account requirement for Farm administrator " failed.  The user is not a farm administrator.

image

 

image
image

 

image

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲