KPIs in Tabular models for Power BI and Excel
A Tabular model can define a measure as a Key Performance Indicator (KPI), thus providing a visual indicator for status and trend. This article describes in detail the KPI settings needed to get the best result using Power BI and… Read more
Creating calculation groups in Power BI Desktop using Tabular Editor
Learn how to create your first calculation group in Power BI Desktop using Tabular Editor in this step-by-step video. Watch now
Relationships in Power BI and Tabular models
This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships. Read more
Updating tabular models for Ordinal property in calculation groups
If you created a Tabular model using one of the preview versions (CTP, RC, …) of Analysis Services 2019, you don’t have the final structure for the Ordinal attribute that Microsoft defined in the final version of compatibility level 1500.… Read more
Change culture/collation of an Analysis Services Tabular database
When you create a Tabular model for Analysis Services, the Culture and Collation properties are set automatically and cannot be changed by the SSDT user interface in Visual Studio. The biggest issue is the workspace database, because these properties cannot… Read more
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. Read more
Tabular Editor
Tabular Editor is an editor alternative to SSDT for authoring Tabular models for Analysis Services even without a workspace server. Free download

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 compatibility version 1200 or later. Free download
Optimizing multi-billion row tables in Tabular
Tabular is a great engine that is capable of tremendous performance. That said, when your model gets bigger, you need to use the most sophisticated tools and techniques to obtain the best performance out of it. In this session we… Watch now
Small benchmark for Tabular and Power BI formula engine (FE) #ssas #tabular #powerbi
If you run SSAS Tabular or Power BI, please help me in gathering some performance data for a study I’m doing about Formula Engine performance following these steps: 1) Copy the PowerShell code below in a script Benchmark.ps1, modifying serverName, ssasInstanceName Read more