Refreshing PowerPivot Data in SharePoint 2013

In SharePoint 2013, Excel Services comes with numerous improvements. One of the most significant for PowerPivot is the ability to refresh data models interactively all the way from the original data sources. Unlike Excel Services in SharePoint 2010, which only queries data models but doesn’t refresh them interactively, Excel Services in SharePoint 2013 first sends… Read more

Power View for Multidimensional Models – Feature Drill Down

On 11/29 we released Preview of Power View connectivity for Multidimensional Models (a.k.a “cubes”). This is achieved through support of tabular metadata of the cube and native support of Data Analysis Expressions (DAX) queries in Analysis Services Multidimensional Models to ensure optimal performance and functionality. We will take a deeper look at how this is… Read more