Microsoft Power Platform Fundamentals — Question 54

You are using Dynamics 365 Sales.
You need to create a Power BI report that includes customer office locations. The City and State columns must be combined to form one column on the report.
What should you do?

Answer options

• A. Use Power Query Editor to merge columns.
• B. Import the data.
• C. Export data to Microsoft Excel.
• D. Create a view.

Correct answer: A

Explanation

The correct answer is A because Power Query Editor allows for the merging of columns directly within Power BI, which is necessary for this task. Options B and C do not address the requirement of combining columns, and D involves creating a view, which is not relevant to the report generation process in this context.