SSAS

ARTICLE

Querying raw data to Tabular

This article describes how to extract raw data stored in the Tabular engine, used by Analysis Service Tabular, Power BI, and Power Pivot.

ARTICLE

Controlling drillthrough using Detail Rows Expressions in DAX

The Detail Rows Expression in a Tabular model provides the user with control over the drillthrough results obtained by showing details of a measure. This article describes typical DAX expressions you can use in this property.

TOOL

Tabular Editor

Tabular Editor is an editor alternative to SSDT for authoring Tabular models for Analysis Services even without a workspace server.

TOOL

DAX Editor

DAX Editor is an extension to SSDT that makes it easier to edit DAX measures in a Microsoft Analysis Services Tabular project.

TOOL

SSAS Tabular Translator

SSAS Tabular Translator is an editor for the JSON translation files exported and imported by SQL Server Data Tools for a Tabular model in compatibility version 1200 or later.

ARTICLE

Storage differences between calculated columns and calculated tables

This article compares the differences between calculated columns and calculated tables from a processing and storage point of view.

ARTICLE

Sessions and preconference at Microsoft Ignite and PASS Summit

In the second half of 2017 I will deliver sessions and preconference days in two big events. I’d like to recap my sessions here, let me know if you have any questions about them. Microsoft Ignite 2017 – September 25-29, 2017 – Orlando, FL Preconference full day – September 24

ARTICLE

Measuring the dictionary size of a column correctly

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular.

ARTICLE

New function and the importance of variables in #dax

I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features appears

ARTICLE

Learn DAX, data modeling, and data visualization after MS Data Insight Summit #dax #powerbi #dataviz

I spent three days in Seattle at Microsoft Data Insight Summit , delivering a preconference day about data modeling for business users, and two workshops about DAX. All of these were sold-out, so even if you attended the conference, you might be interested