Which tool should you use?

Topic 3, Demonstrate the business value of Power BI

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?
A . Query Editor
B . Power BI Service
C . Microsoft Excel
D . Data Connector

View Answer

Answer: A

Explanation:

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.

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview