Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
When I have a snowflake schema and want to use a star schema instead, then best practice is to use the query editor to merge the related DIM tables. Is this correct? For example, based on the diagram below, I would use the query editor to merge "Dim Event Details" with "Dim Event"?
Solved! Go to Solution.
@TimmK , merge product and product category into one table .
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Ah ok, thanks. Maybe the example above was not a good one. How about the one below? Here, it would be best practice to merge "product_category" and "product" in the query editor to get the star schema, right?
@TimmK , merge product and product category into one table .
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
@TimmK , One event is having more than one detail, how you want to filter event fact from this.
Because events table only has EventID. So ideally model is fine unless you want to have interaction between event fact and event details
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |