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 change the semantic model mode. Does this meet the goal?

Question

Accepted Answer

B. No Changing the semantic model mode (e.g., from DirectQuery to Import) affects how data is stored and queried but does not automatically cleanse or normalize data to resolve underlying case sensitivity issues or data errors from the source. The data quality problem would persist regardless of the storage mode unless explicit data transformation steps are applied.

Answer

A. Yes Altering the storage mode of the semantic model (e.g., from DirectQuery to Import) does not inherently fix data content problems like case sensitivity or undefined values; these require data cleaning or transformation.

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…

Question

Options

How the community answered

Why each option

Community Discussion