While the capabilities previously provided with Excel Services have been moved to Office Online Server (OOS) in the 2016 version of SharePoint, PowerPivot for SharePoint (PP4SP) has not. PP4SP remains a… Continue reading Using PowerPivot for SharePoint with SharePoint 2016
Category: SQL Server
Connecting Excel to Data with SharePoint 2016 and Office Online Server 2016
If you’re in the SharePoint community, and you’ve been living under a rock since August 2015, you may not have heard that Excel Services is no longer present in SharePoint… Continue reading Connecting Excel to Data with SharePoint 2016 and Office Online Server 2016
What’s Happening to Excel Services in SharePoint 2016
Excel Services is dead – long live Excel Online. With the release of the first public preview of SharePoint Online, and the release of this TechNet article, the news rapidly… Continue reading What’s Happening to Excel Services in SharePoint 2016
Connecting to Analysis Services in Power BI
At the moment (July 2015), SQL Server Analysis Services (SSAS) data has the widest range of connection options in Power BI. This is a good thing, but the flip side… Continue reading Connecting to Analysis Services in Power BI
Analysis Services Power Pivot Mode in 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