Microsoft Power Platform Fundamentals — Question 57

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?

Answer options

• A. Query Editor
• B. Power BI Service
• C. Microsoft Excel
• D. Data Connector

Correct answer: A

Explanation

The Query Editor is the appropriate tool for transforming and merging data from different sources, allowing you to associate the store names with the transaction data. The other options, such as Power BI Service, Microsoft Excel, and Data Connector, do not provide the same level of data transformation capabilities necessary for this task.