A company manages a chain of retail stores. The company stores a list of retail store names and numbers in one Power BI table. The company stores sales transaction data including a transaction ID in another table.

The transaction ID includes the store number.

You need to show the store name for all retail transactions in all Power BI reports.

Which tool should you use?