Tips & Tricks

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 – Apply Default Translations

Exporting Translations Tabular Editor lets you export translations into the same .json file format used by Visual Studio and SSAS Tabular Translator. This is useful if you want to delegate the task of translating your model to someone without access to your tabular model metadata. Let’s say you’ve added a new culture (called “translation” within Tabular …

Tabular Editor Tricks – Apply Default Translations 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 »

Scroll to Top