2024

1 article
AutomationTools

Direct Lake Migration

We are all familiar with import and DirectQuery as query modes for Analysis Services and Power BI semantic models. However, with the release of Microsoft Fabric, there is a new kid on the block - Direct Lake!

4 min read 9.8K views 8 comments

2022

1 article
AutomationTools

Processing Unprocessed Objects

Learn how to automate the processing of tables/partitions which need to be processed in your model.

3 min read 3.7K views 1 comment

2021

12 articles
DocumentationAutomation

Export Power BI Report Objects

Learn how to easily export metadata of visuals, filters and other objects within your Power BI report.

4 min read 12.2K views 25 comments
AutomationPower BI Premium

Convert Data Sources for Premium Migration

Easily overcome a potential data source issue when migrating to Power BI Premium.

3 min read 3.8K views 6 comments
DocumentationAutomation

Migrating Report-Level Measures to the Model

Learn how to push your report level measures into your tabular model!

4 min read 8.9K views 15 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
DocumentationAutomation

Automated Data Dictionary via Excel

Learn how to create an automated data dictionary via Excel.

4 min read 5.8K views 3 comments
AutomationTools

Processing Manager

A tool for managing the processing of large tabular models.

5 min read 6.5K views 21 comments
AutomationTools

Cancelling a Power BI Data Refresh Using Azure DevOps

Learn how to cancel a Power BI Premium data refresh using Azure DevOps.

3 min read 2.7K views 2 comments
AutomationTools

Data Refresh in Tabular Editor

A simple way to process table(s), partition(s) or the model in Tabular Editor.

3 min read 19.9K views 4 comments
AutomationTools

Cancelling a Dataset Refresh Using Tabular Editor

Learn how to programmatically cancel a dataset refresh using Tabular Editor.

2 min read 5K views 10 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

6 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
Tabular OptimizationAutomation

Auto-Generated Aggregations

Generate aggregation tables automatically for your model.

8 min read 3.8K views
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
DocumentationAutomation

Extract Model Metadata

Quickly extract model metadata into a user-friendly output.

3 min read 14.7K views 11 comments
AutomationBest Practices

Model Auto Build

Dynamically create a tabular model based on an Excel template.

4 min read 3.6K views

2019

5 articles
DocumentationAutomation

Track Model Modes and their creator

Learn how to create autonomous monitoring of your tabular model.

5 min read 629 views
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
DocumentationAutomation

The Automated Data Diagram

Visualize your data model's relationships in a simple and elegant manner.

7 min read 1.6K views
DocumentationAutomation

How to create an automated data dictionary

Creating an automated data dictionary via metadata

10 min read 10.1K views 3 comments
Tabular OptimizationAutomation

Master Model: Creating Derivative Tabular Models

Use this technique to create tailored solutions for different user groups all while further optimizing performance.

10 min read 11.1K views 6 comments
Search articles