What’s new for SQL Server 2016 Analysis Services in CTP3.2

What is new in SQL Server Analysis Services 2016 CTP3.2 Just a few weeks after releasing SQL Server Analysis Services 2016 CTP3.1, we are delivering a new update to Analysis Services again. This month’s updates are focused on tabular models at the 1200 compatibility level and include scripting in SSMS, calculated tables, and DirectQuery. Scripting… Read more

White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016

The PowerPivot add-in for SharePoint Server 2016 was published for the first time as part of the  Microsoft SQL Server 2016 Community Technology Preview (CTP) 3.1 Feature Pack. Now customers can take advantage of SharePoint 2016 in their I-enabled farms and benefit from infrastructure advancements, compliance and security enhancements, and numerous performance and reliability improvements…. Read more

What’s new for SQL Server 2016 Analysis Services in CTP3.1

After last month’s SQL Server Analysis Services 2016 CTP3 we are shipping yet again this month, with even more updates to Analysis Services. You can now upgrade your model to the SQL Server 2016 compatibility level, use the Visual Studio JSON editor to edit the Tabular BIM file and manage roles directly in SSDT.  Upgrade a Tabular… Read more

What’s new for SQL Server 2016 Analysis Services in CTP3

We are really excited to announce the SQL Server 2016 Analysis Services CTP 3 update can be downloaded within the next few days here. This month’s update includes some great improvements and features that we think you will be very excited about. If this is your first look at Analysis Services in SQL Server 2016 Preview, here is… Read more

Using Extended Events with SQL Server Analysis Services 2016 CTP 2.3

Extended Events were introduced into Analysis Services in SQL Server 2012. This made use of a common XE module that was shared with SQL Server Database Engine. The challenge with Extended Events is that it can be complicated to configure going on scripting alone. You need to know what events are available, and how you… Read more

Parallel partition processing available for Tabular Models in SQL Server 2016 Preview

One of the great new features that was actually added back in CTP 2.0 of SQL Server 2016 Preview is the ability to process partitions in a table in parallel for Tabular Models.  Today I want to highlight this highly requested feature and show you what this might mean for your Tabular models. With parallel partition… Read more

SQL Server Analysis Service 2016 CTP 2.3 DirectQuery in action

In my previous blog post “What’s new in Microsoft SQL Server Analysis Services Tabular models in SQL Server 2016 CTP 2.3” I introduced some of the enhancements coming to SQL Server Analysis Services Tabular –and many more will be coming in the next CTPs. In this article, I’d like to show you what the combination… Read more

What’s New in Microsoft SQL Server Analysis Services Tabular models in SQL Server 2016 CTP 2.3

This is an exciting time for SQL Server Analysis Services as we start to release updates to our Analysis Services Tabular engine as part of SQL Server 2016 CTP 2.3 preview This blog post introduces some of the enhancements coming to SQL Server Analysis Services Tabular and many more will be coming in the next… Read more

Data mining and Power Pivot for Excel 2010 add-in issues with Windows 10 and Visual Studio 2015

Update: Download the latest version of Data Mining add ins here that solve this issue. Unfortunately with the release of Windows 10 and Visual Studio 2015 an issue was found in the 64 bit versions of the following products: PowerPivot for Microsoft Excel 2010 Data Mining Add-ins for Microsoft Excel (Table Analysis Tools and Data Mining… Read more