Skip to content

Tag: SSAS

SSAS 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 and I was surprised that the “lost” dimensions were perfectly visible to me. On this particular SSAS Tabular Model, we…

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.…