Evaluating Shared Expressions in Tabular 1400 Models

In our December blog post; Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services, we mentioned SSDT Tabular does not yet support shared expressions, but the CTP 1.1 Analysis Services engine already does. So, how can you get started using this exciting new enhancement to Tabular models… Read more

What’s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services

The public CTP 1.1 of SQL Server vNext on Windows is available here! This public preview includes the following enhancements for Analysis Services tabular. New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This enables: Support for additional data sources, such as MySQL. Additional data sources… Read more

Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services

Starting with SQL Server vNext on Windows CTP 1.1, Analysis Services features a modern connectivity stack similar to the one that users already appreciate in Microsoft Excel and Power BI Desktop. You are going to be able to connect to an enormous list of data sources, ranging from various file types and on-premises databases through… Read more

How SQL Server 2016 and Power BI empower Mediterranean Shipping Company (MSC)

Here’s a great case study about Mediterranean Shipping Company optimizing their business processes by taking advantage of the SQL Server 2016 Database Engine, Analysis Services, and Power BI. If you are particularly interested in Analysis Services, you might enjoy reading the section about complying with new Safety of Life at Sea Convention (SOLAS) requirements, which… Read more

Improving Analysis Services Performance and Scalability with SQL Server 2016 Service Pack 1

SQL Server 2016 Analysis Services delivered numerous performance improvements over previous releases, such as better modeling performance thanks to the new 1200 compatibility level for tabular databases, better processing performance for tables with multiple partitions thanks to parallel partition processing, and better query performance thanks to additional DAX functions that help to optimize the client/server… Read more

Improving the Measure Grid in SSDT Tabular

As the name implies, the measure grid is an SSDT Tabular feature to define and manage measures, as illustrated in the following screenshot. It is available for each table when you work in Data View in Tabular Model Designer. You can toggle it on and off by using the Show Measure Grid option on the… Read more

Introducing Azure Analysis Services

We are pleased to announce the availability of Microsoft Azure Analysis Services preview. With Azure Analysis Services, BI professionals can create BI semantic models based on data that resides in the cloud or on-premises, whether that’s SQL Server, Azure SQL Database, Azure SQL Data Warehouse or other data sources to provide business users with a… Read more

Introducing Integrated Workspace Mode for SQL Server Data Tools for Analysis Services Tabular Projects (SSDT Tabular)

When you work with the model designer in SSDT Tabular, you are working with a temporary Analysis Services database that SSDT Tabular automatically loads on a workspace server. During the initial project creation, you must point SSDT Tabular to the desired workspace server, which must be a tabular Analysis Services instance that you can control… Read more

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