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…

The correct answer is A. Query Editor. Query Editor (Power Query) in Power BI is the right tool here. You need to merge data from two separate tables - the store list (names and numbers) and the sales transactions (which embed the store number inside the transaction ID). In Query Editor, you can extract the store…

Submitted by thandi_sa· Apr 18, 2026Describe the business value of Microsoft Power Platform

Question

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?

Options

AQuery Editor
BPower BI Service
CMicrosoft Excel
DData Connector

How the community answered

(45 responses)

A
87% (39)
B
2% (1)
C
7% (3)
D
4% (2)

Explanation

Query Editor (Power Query) in Power BI is the right tool here. You need to merge data from two separate tables - the store list (names and numbers) and the sales transactions (which embed the store number inside the transaction ID). In Query Editor, you can extract the store number from the transaction ID string, then merge or join the two tables on that common field so the store name appears alongside every transaction record. This transformation is applied once during data preparation and automatically flows into all reports built on that dataset.

Topics

#Power BI#Query Editor#Data Transformation#Data Integration

Community Discussion

No community discussion yet for this question.

Full PL-900 Practice