Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I know you have the diagrammatic view of relationships in power bi, but is there a quick way to see like in a table format to see what tables are mapped to where and on which key? The reason i ask is because i have a HUGE model with 30+ tables and its really annoying to have to go and click on each relationship to see what its mapped to - is there another way of pulling those relationships where i can see them all in a textual manner?
Proud to be a Super User!
Solved! Go to Solution.
Have you tried hitting "Manage Relationships" in the Modeling tab on the ribbon?
Have you tried hitting "Manage Relationships" in the Modeling tab on the ribbon?
its not on the modelling ribbon is on the home ribbon but that works thank you!
Proud to be a Super User!
It's an interesting question. I teach Power Pivot and I sometimes get asked similar questions. I always tell people that they don't need to know. Tables either have a relationship or they don't. If they do, then they are related - that's it. It should be irrelevant which columns are used for the relationship (assuming it was done correctly). So certainly if a model is not working, then there is a need to check the relationship to see if a mistake has been made. But if it is working, then it's working, and there is no need to know which is the keyed columns.
Thats my view anyway.
Power pivot utilities for Excel can extract info like this from a power pivot model, but it doesn't work for Power BI. I am sure ther meta data is there in a DMV somewhere but I don't know which one.
if only it was that simple Matt! 🙂
Im in the stages of mapping all the relationships i need for my model, i just want to make sure i haven't missed any and also ensure ive done it on the right key, so it is actually required from a point of due dilligence.
The other way to find out is when things dont work. Not the ideal.
Proud to be a Super User!
How many relationships do you have?
well i have 2 fact tables and minimum 30 dimensions linking to them
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |