Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
To be honest I am completely new to Data Warehouse practices and as an assignment, I need to design a data warehouse using star-schema for car accidents in a country. At first, I have designed the FactTable as Accident with measures QtyCars and QtyCasulties with dimensions: "Driver", "Car", "Casualties", "Location", "WhatherConditions".. but then I have realized that they are many to many relationships for example: Accident 1: there is only one vehicle with two casualties. Acc 2: there are two vehicles, the first with one casualty the second with two. Acc 3: there were three vehicles. The first with three casualties, the second with two but, the third vehicle has no casualties. What should I change in the schema below?
Solved! Go to Solution.
Hi naciass,
Many to many relationship is now supported by power bi. You can use composite model in power bi, for details, please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships.
Regards,
Jimmy Tao
Hi naciass,
Many to many relationship is now supported by power bi. You can use composite model in power bi, for details, please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships.
Regards,
Jimmy Tao