Microsoft Power Platform Fundamentals — Question 271

You are using Dynamics 365 Sales.
You need to pull data into a Power BI report for your team. The City and State columns must be combined to form one column on the report.
Which function would you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Answer options

• A. Use Power Query 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 using Power Query allows you to merge columns effectively, which is necessary for combining the City and State into one. Options B and C do not accomplish the task of merging columns, and option D only creates a view without modifying the data structure needed for the report.