Table Relationships

Allow table relationships based on multiple columns, similar to the SQL Server join.

Would facilitate more complex data modeling

In many cases, table relationships depend on multiple columns (e.g., Customer_ID + Date), and having this functionality would eliminate the need to create artificial composite keys.

Would reduce the need for extra data manipulation

Currently, users have to create calculated columns to concatenate values and simulate a composite key, which can be unintuitive and may even impact performance.

Closer to SQL logic

In SQL Server and other databases, it is common to use multiple fields to join tables. Bringing this logic to Power BI would make the tool more powerful and aligned with common data modeling practices.