Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
New to Power BI and have come across a dataset that I am exploring and have an issue that I don't know how to solve when it comes to modelling and building relationships.
I was hoping to get some help from the community.
I have this table with three columns that I have renamed to "Inventory_Lookup" (see pic) that I'm not able to connect correctly. I have listed my questions below.
- Is this a lookup/dimension table? Or is it actually a fact/data table?
- How do I connect it properly since there are no unique values in the table? Have I done it the right way as shown in the picture (both directions from sales table to product_lookup and one to many from product_lookup to Inventory_lookup)?
Thanks in advance.
Solved! Go to Solution.
Hi @Clay82 ,
But, yes all the relationships in a data model depend on what you re planning to analyse in your report and at what granularity.
Thanks,
Pragati
Hi @Clay82 ,
But, yes all the relationships in a data model depend on what you re planning to analyse in your report and at what granularity.
Thanks,
Pragati
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |