2022

1 article
Power BI PremiumBest Practices

Rectifying the Misconceptions of XMLA Read/Write

Learn the importance of enabling XMLA Read/Write

6 min read 4.5K views 10 comments

2021

7 articles
Best PracticesVisualization

Report Analyzer Recos

Report Analyzer now has a recommendations engine for report best practices!

2 min read 4.2K views 1 comment
ToolsBest Practices

Report Analyzer

A productivity tool for analyzing a Power BI report's performance.

3 min read 24.6K views 7 comments
DocumentationBest Practices

Export Best Practice Analyzer Results

Learn how to export the results of the Best Practice Analyzer.

2 min read 6.1K views 2 comments
DocumentationAutomation

The Best Way to Manage Descriptions

Learn the best method for adding descriptions to objects in your model.

5 min read 10.1K views 26 comments
Tabular OptimizationAutomation

Quantify the Savings of Best Practice Rules

Learn how to quantify the savings of following a particular best practice rule.

3 min read 7.1K views
DocumentationAutomation

Automated Data Dictionary - Reinvented

A new method to create an automated data dictionary which also works for Power BI Premium models.

3 min read 5.5K views 12 comments
DocumentationAutomation

Import VPAX Data into Tabular Editor

Import Vertipaq Analyzer data from a .vpax file into Tabular Editor.

1 min read 1.8K views 5 comments

2020

5 articles
AutomationBest Practices

Find Relationships Causing Blank Rows

An automated way of scanning your model to find the cause of blank rows in your model.

2 min read 3.4K views 4 comments
Tabular OptimizationAutomation

Vertipaq Analyzer in Tabular Editor

See Vertipaq Analyzer stats in Tabular Editor and create Best Practice rules around them.

4 min read 11.8K views 12 comments
AutomationDAX

Data Preview in Tabular Editor

Learn how to see a preview of your data in Tabular Editor.

3 min read 4.7K views 2 comments
AutomationBest Practices

Model Auto Build

Dynamically create a tabular model based on an Excel template.

4 min read 3.6K views
DAXBest Practices

Variations on a theme: Dynamic RLS Patterns

Explore the options when implementing Row Level Security in your tabular model.

6 min read 4.2K views

2019

4 articles
DocumentationBest Practices

Tabular Style Guide

Naming and formatting standards for Tabular models.

7 min read 6.2K views 2 comments
Tabular OptimizationBest Practices

Direct Query & Composite Models

Learn when to use Direct Query or Composite Models.

4 min read 1.6K views
Tabular OptimizationDAX

Top 10 Power BI mistakes and their best practice solutions

Follow these best practices as a baseline for an elegant tabular model.

13 min read 42.1K views 6 comments
AutomationDAX

Automate the best practice of proper column & measure references

Automate the best practice of setting proper column/measure references through the Best Practice Analyzer.

2 min read 4.8K views 1 comment
Search articles