Microsoft Power BI Data Analyst — Question 125

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a data source that contains a column. The column contains case sensitive data.

You have a Power BI semantic model in DirectQuery mode.

You connect to the model and discover that it contains undefined values and errors.

You need to resolve the issue.

Solution: You add an index key and normalize casing in the data source.

Does this meet the goal?

Answer options

Correct answer: A

Explanation

Adding an index key and normalizing the casing in the data source effectively addresses the issue of case sensitivity and undefined values in Power BI. This ensures that the data can be queried consistently without errors due to casing discrepancies. The other option, 'No', is incorrect as the proposed solution is indeed an appropriate method to resolve the stated problem.