Because the field names are not identical in this example, you would need to use Excel’s Create Relationship tool (available from the PivotTable menu ... Power BI Desktop, and SQL Server Analysis ...