MENU
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?
Suggested Answer: A
Get Premium PL-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
Power BI Desktop comes with Query Editor, where you can connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.
https://docs.microsoft.com/en-us/power-bi/desktop-query-overview
12 comments · newest first
DE
Desirae
12 months ago
Isn't Microsoft Excel a bit outdated for this kind of task?
NO
Noelia
1 year ago
Query Editor makes sense, but I'm surprised it's not just a simple drag-and-drop.
PR
Providencia
1 year ago
I thought Power BI Service could do that too?
MA
Madalyn
1 year ago
Definitely agree, Query Editor is the way to go!
LE
Leota
1 year ago
You need to use Query Editor for this.
KA
Kasandra
1 year ago
I remember we discussed how to display related data in reports, but I can't recall if it was specifically about using Power BI Service or something else.
HY
Hyman
1 year ago
This question reminds me of a practice scenario where we had to relate two tables. I feel like the Data Connector could also be relevant here.
JU
Justine
1 year ago
I think we might need to use the Query Editor to merge the tables, but I'm not entirely sure if that's the right approach.
SH
Shenika
1 year ago
I’m leaning towards Query Editor since it’s often used for data transformation, but I wonder if there’s a simpler way to achieve this in Power BI.
BR
Brandon
1 year ago
This seems pretty straightforward. I just need to make sure I allocate the overhead costs correctly and then subtract the total costs from the selling price to get the profit per unit.
AN
Annelle
1 year ago
I'm pretty sure the answer is B. In a MIL test environment, you can access the system at any point through access points, so stimulations and observations are possible anywhere.
AL
Alisha
1 year ago
Hmm, I'm a bit unsure about this one. The "Analyze in Excel" option is something I remember learning about, but I can't quite recall where it's located in the Power BI interface. I'll need to think this through step-by-step.