Introducing Tabular Model Explorer for SQL Server Data Tools for Analysis Services Tabular Projects (SSDT Tabular)

If you download and install the August 2016 release of SQL Server Data Tools (SSDT) for Visual Studio 2015, you can find a new feature in SSAS Tabular projects, called Tabular Model Explorer, which lets you conveniently navigate through the various metadata objects in a model, such as data sources, tables, measures, and relationships. It… Read more

Bidirectional cross-filtering whitepaper

Bidirectional cross-filtering is a new feature for SQL Server 2016 Analysis Services and Power BI Desktop that allows modelers to determine how they want filters to flow for data using relationships between tables. In SQL Server 2014, filter context of a table is based on the values in a related table. With bidirectional cross-filtering the… Read more

On Demand Webinar “What’s New for SQL Server 2016 Analysis Services” available now

This week I did a live webinar on what is new in  SQL Server 2016 Analysis Services: Everything you want to know about SQL Server 2016 SQL Server Analysis Service. In this session we will look at how Analysis services tabular models simplify solving complex business problems using over 50 new DAX functions and how new… Read more

What is new in SQL Server Analysis Services 2016 RC0

With the release of SQL Server 2016 RC0, we’ve added more capability for modeling and managing Tabular models set at the SQL Server 2016 compatibility level (1200). RC0 brings us one step closer to general release by adding display folders, full-fledged PowerShell support for Tabular 1200 models and instances, SSIS administration of SSAS Tabular workloads,… Read more

Try out SQL Server 2016 Analysis Services CTP 3.2 on the TechNet Virtual Lab

Recently we released a great TechNet Virtual Lab that will take you through many of the new enhancements in SQL Server 2016 Analysis Services through the great virtual environment of the TechNet labs. In this lab you will learn to: Create and monitor Extended Events (xEvents) Upgrade a tabular project to SQL Server 2016 (compatibility level 1200)… Read more

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

What is new in SQL Server Analysis Services 2016 CTP3.3 It is a new year and again we are delivering more updates to Analysis Services with SQL Server 2016 CTP3.3. This month’s update delivers support for calculated columns and row level security for DirectQuery, translations for Tabular models into different languages, additional performance optimizations and… Read more

Second White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm

Last month, we published a white paper about Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016  in a demo environment based on a single-server farm. Given this paper’s high popularity, Jason then suggested that it would also be useful to provide deployment instructions for a multi-server farm with separate front-end and application… Read more

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