Forum Discussion
Power BI Data Modelling Snowflake to Star Schema
I have recently realised that the STAR schema is the recommended data model for power BI, and even the snowflake schema isnt the recommended approach An event can have many details (Agenda ...
I still down know how I merge the two event table together though when it comes to the keys
I have no clue how to go about it. Do I then just have one ID in the Event dimension and have multiple rows for each event
I dont understand how this will work against the Fact table ?
So in the merged Event dim should I have
EventID AgendaID
1 1
1 2
1 3
1 4
And then you have the fact table joined to the Event ID?
can you share some dummy data or data in text form and i can create it for you as an example.