Learn Power BI

Tables with different levels of granularity need to be reconciled before establishing a relationship between the tables.

Tables should always be as granular as possible so that users can drill into every single transaction