Enable PowerPivot Support in Office Online Server 2016 and Sharepoint 2016

SharePoint has supported PowerPivot enabled workbooks since they were first introduced with the initial PowerPivot for Excel Add-On. This support was initially provided via PowerPivot for SharePoint, which was comprised of… Continue reading Enable PowerPivot Support in Office Online Server 2016 and Sharepoint 2016

Rethinking Business Intelligence in SharePoint and SQL Server 2016

SharePoint 2016 and SQL Server 2016 will both be released in 2016, adding to the changing Business Intelligence landscape already being disrupted by Power BI. Many of them will be… Continue reading Rethinking Business Intelligence in SharePoint and SQL Server 2016

Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint

Using Excel Services, SharePoint users have been able to share workbooks that are connected to back end data since SharePoint 2007. Typically, the connection is made to SQL Server, or… Continue reading Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint