13 Nov, 2024

Help – I want Tabular Model Documentation

A few months ago, I chatted with colleagues about our Tabular Model. More specifically the lack of Tabular Model documentation. Since we were thinking about replacing our current model, I started to think about how to integrate documentation easily. Having documentation is 1 thing, making sure it’s used is something completely different. And then we’re […]

4 mins read

Tabular Model – Help – Can’t create a DAX Calculation Group

Recipe Overview Preparation Time: 5 minutes Ingredients Problem Statement While I was writing another data recipe, I ran into an issue. For some reason, the “Create Calculation Group” was not visible / enabled in Tabular Editor. I tried to create a Calculation Group by right-clicking on the Table Folder –> Create but the option wasn’t […]

2 mins read

Tabular Model – DAX Time Intelligence functions with an alternative Financial Year-ending

Recipe Overview Preparation time: 10 minutes Ingredients Problem Statement Many companies don’t follow the regular Calendar as we know (January 1st – December 31st). They follow their own Financial Calendar (often called Fiscal Calendar) which can start any time of the year. Because of this, writing DAX Year-To-Date calculations for your Tabular Model might seem […]

3 mins read

Tabular Model – Help – SortByColumn property set to an invalid column ID

Problem statement Since a couple of weeks, we have been redesigning our SSAS Tabular Model. We are keeping the model as user-friendly as possible and we try to minimize overhead for our end-users to a bare minimum. During this process, we were configuring certain properties for every column in our model like Display Folder, Hidden, […]

3 mins read

Tabular Model – Help – I can’t find my Dimensions in Excel

Problem statement A colleague reached out last week while connecting to one of our SQL Server Analysis Services models in Excel. He couldn’t find the expected Attribute folders in the model. He was looking for the following dimensions: So I started to investigate. As a first test, I connected to the same model in Excel […]

2 mins read

Azure DevOps Pipelines – Release your Tabular Model without Users & Roles

Problem statement A couple of weeks ago my team & I ran into an issue with SQL Server Analysis Services (SSAS), due to a network split between companies, We weren’t able anymore to manage our SSAS access into our SSAS Tabular Model. Since deploying a Tabular Model using Visual Studio is also overwriting members & […]

4 mins read