C# Scripting

CI/CD scripts for Tabular Editor 2’s CLI

Tabular Editor 2’s CLI is often used in CI/CD pipelines (Azure DevOps, GitHub Actions, etc.) to perform certain tabular model related actions, such as running a Best Practice Analysis, performing a schema check or deploying the model to a destination server. The CLI was designed in 2016, before Power BI and even Azure Analysis Services …

CI/CD scripts for Tabular Editor 2’s CLI Read More »

Translate your measures using Tabular Editor and GPT3

There is a lot of hype these days about Large Language Models. While they are excellent for some tasks, they still can’t replace a good BI developer. However – they can be used for a lot of helpful things, so heavily inspired by the great articles written by Darren Gosbell:Automatically generating measure descriptions… & Generating …

Translate your measures using Tabular Editor and GPT3 Read More »

Generating a dynamic measure selector

Dynamic measure selectors For certain kinds of reports, it sometimes makes sense to be able to select which measures should be displayed by checking off members on a dimension, rather than including individual measures from the field list. There are many blogs and articles online that describe this pattern in more details. You can find …

Generating a dynamic measure selector Read More »

Tabular Editor Tricks – Convert to Legacy

Converting partitions from M to Legacy When building Analysis Services tabular models on top of a Data Warehouse or Data Mart on a relational database, I recommend using the Legacy (Provider) data sources instead of the Power Query data sources available since SQL Server 2017. Unfortunately, Power Query data sources have become the default in …

Tabular Editor Tricks – Convert to Legacy Read More »

Power BI Tricks – WhatIf parameters

Update May 29th 2019: It turns out that the technique outlined here can be used for SSAS or Azure Analysis Services Tabular models of Compatibility Level 1400+. In fact, just by adding the ParameterMetadata Extended Property (step 9 below) to any numeric column in your model, you can instruct Power BI to display a single-select slider as …

Power BI Tricks – WhatIf parameters Read More »

Scroll to Top