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.
I am having issues with the above model/path.
1. Fact table has the product key
2. Product Dimension (think of this as whole units) has the product key
3. The replacement Glass DIM has a list of glass components that could belong to a single product. i.e. one window unit has multiple glass panes of different size.
I've tried attaching the two dimension tables with a bridge table that contains all of the product keys and their corresponding child item codes (the glass codes). Child item codes could be used in multiple products.
I'm hoping to create a table visual that has attributes from the fact table and both dimension tables, however, when I try to combine attributes from the fact table and the snowflaked/bridged dimension table I recieve the below error. What am I missing?
Solved! Go to Solution.
This looks very similar to the banking scenario design with multiple customers associated to accounts and then transactions.
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
What specifically is not working that is generateing the error you provided? We might need to better understand the visual you are trying to create and the columns involved to provide some suggestions.
This looks very similar to the banking scenario design with multiple customers associated to accounts and then transactions.
https://docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
What specifically is not working that is generateing the error you provided? We might need to better understand the visual you are trying to create and the columns involved to provide some suggestions.
@dsynan , bridge table should have between fact to fact. or fact to dimension.
Why there need join to M-M dimension. Can the other not join with fact ?
It would be M-M if joined to the fact table. multiple products can use the same set of components from that second dimension table
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |