Wednesday, 20 July 2016 15:29
Posted by Derek Halstead

You’ve just created a new site template and you’re now wondering if you could use the custom site template to create a new site collection using PowerShell.

Tuesday, 19 July 2016 12:37
Posted by Derek Halstead

Learn to configure constrained kerberos delegation from Excel or PowerPivot in SharePoint 2013 to an external SQL Server in the same domain.

Wednesday, 15 June 2016 09:51
Posted by Derek Halstead

Analysis Services TABULAR SQL Server Data Tools – How to Import Power Pivot Project

Thursday, 26 May 2016 16:07
Posted by Derek Halstead

Get-SPServiceApplication | Select Name, @{Name=”SPAppPoolName”; Expression={$_.ApplicationPool.Name}}, @{Name=”IISAppPoolName”; Expression={$_.ApplicationPool.Id}}, @{Name=”ProcessAccountName”; Expression={$_.ApplicationPool.ProcessAccountName}} Get-SPServiceApplication | Select Name, @{Name=”SPAppPoolName”; Expression={$_.ApplicationPool.Name}}, @{Name=”ProcessAccountName”; Expression={$_.ApplicationPool.ProcessAccountName}}

Friday, 13 May 2016 14:38
Posted by Derek Halstead

Exception calling “Open” with “0” argument(s): “Call to Excel Services returned an error.”

Friday, 13 May 2016 14:33
Posted by Derek Halstead

Exception calling “Open” with “0” argument(s): “The connection cannot be opened because the redirector service did not provide required database information.”

Thursday, 05 May 2016 14:05
Posted by Derek Halstead

Is there a way to put a Power Pivot slicer into an Excel Services web part?