Home ยป Analysis Services
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…
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…
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.…
