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
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
It is fairly well known that ever since SQL Server 2012, users have been able to install SQL Server Analysis Services (SSAS) in one of two modes – either “Multidimensional… Continue reading Analysis Services Power Pivot Mode in SQL Server 2016
Excel has been used with external data for… well, as long as I’ve been using Excel. So why would anyone bother to write a blog post about this given that… Continue reading Using Excel With External Data – What’s the Right Tool?
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