Skip to content

Category: Analysis Services

Help – Which Attributes & Measures can I combine from my Tabular Data Model?

In this blog post, I will guide you through all the required steps to get a Data Model Relationship Matrix in Power BI. If you don’t know what I mean, I would like to have a straightforward overview where I can see which attribute groups and measure groups I can combine from my Tabular Model in (SQL Server) Analysis Server. By the end of this blog post, we will have created the following overview: You…

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 & roles, we needed to find a valid alternative to execute our deployments. Manually at first and automated in the end.…