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 »
Last week our CTO Daniel Otykier yet again was involved in a thread on Twitter, where Micah Dail suggested creating a script to annotate Role members with their human readable information instead of the AAD Guids that doesn’t make sense to humans. I’ve got a script idea that would be great but I’m struggling to
Annotate role members by querying Microsoft Graph Read More »
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 »
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 »
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 »
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 »
