![]() In the query window, I tried the following query: SELECT measuregroup_name AS MeasureGroupName, Tabular Model Based on AdventureWorksDWĪs soon as the deployment was done, I started SQL Server Management Studio (SSMS) and connected to my SQL Server Analysis Servces Instance.Īs a second step, I right click on my AdventureWorkDW Model, go to New Query and choose MDX. Step-by-step Example Getting the dataįor this step-by-step example, I have used the AdventureWorkDW as a source database and I quickly created a very small Tabular Model to be able to go through the process with an approachable model.Īs a first step I renamed them to a more end-user-friendly name, and to continue I deployed my basic Tabular model to SQL Server Analysis Services. Our idea: “Why don’t we leverage the Tabular model information in Analysis services?”Īfter a couple of minutes, we had our dataset with the required information and could start to get this information in a Power BI report. Which in the end could be really useful for us and our end users.Īfter a chat between my colleague and myself, we came up with the idea that there should be a more manageable way to do it. The colleagues from the other BI team were busy making a matrix to show the dependencies between all attributes and measures available in the Tabular Model in SQL Server Analysis Services. Since we are still keeping close contact and chatting about what we are working on, we got a couple of ideas after the talk. Not so long ago, a couple of things changed at work, instead of working on a group level as I was used to, the BI team I was working in was split into 2 separate BI teams both focusing on a particular concept. Quick Overview Background Story – Use Case Step-by-step Example - Getting the data - Power BI Useful Links Background Story – Use Case To make it more fun, we currently have multiple models. You may think, why would you need it? Well, in my case, I inherited a data model which has a lot of attributes and measures (I really mean a lot, speaking here about more than 1000 attributes and measures) all divided over more than 50 dimensions and facts. 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.īy the end of this blog post, we will have created the following overview: In this blog post, I will guide you through all the required steps to get a Data Model Relationship Matrix in Power BI.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |