PL-900 · Question #63
PL-900 Question #63: Real Exam Question with Answer & Explanation
The correct answer is A: Use Power Query to merge columns.. Power Query, accessed through Query Editor in Power BI Desktop, provides a Merge Columns transformation that combines the City and State columns into a single column using a chosen separator (for example, producing 'Austin, TX'). This transformation is applied during the data pre
Question
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?
Options
- AUse Power Query to merge columns.
- BImport the data.
- CExport data to Microsoft Excel.
- DCreate a view.
Explanation
Power Query, accessed through Query Editor in Power BI Desktop, provides a Merge Columns transformation that combines the City and State columns into a single column using a chosen separator (for example, producing 'Austin, TX'). This transformation is applied during the data preparation stage before the model is loaded, so the combined column is available in every report built on that dataset. Simply importing data (B) does not transform the column structure. Exporting to Excel (C) moves the problem outside Power BI rather than solving it within the report. Creating a Dynamics 365 view (D) changes how data is presented in Dynamics 365 itself but has no effect on column shaping inside a Power BI report.
Topics
Community Discussion
No community discussion yet for this question.