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
Tag: Analysis Services
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
Using the new Excel 2013 Data Model with SharePoint
One of the biggest new features in Excel 2013 is the ability to import and analyze massive amounts of multi tabular data. However, it’s not really all that new –… Continue reading Using the new Excel 2013 Data Model with SharePoint
Connecting to Cubes and External Data with Excel in SharePoint
While many people are still unaware of it, Excel 2010 (and even previous versions) is a very powerful business intelligence client. That’s right, I said Excel. And I don’t mean… Continue reading Connecting to Cubes and External Data with Excel in SharePoint