When using DirectQuery, which feature is not available?

When using DirectQuery, which feature is not available?

• A. Creating new measures
• B. Using calculated columns
• C. Using parent-child DAX functions
• D. Changing data source settings

Answer: (C)

In Power BI, when utilizing DirectQuery as the connection mode to your data source, certain limitations are imposed regarding data manipulation within the model. One key feature that is not available in DirectQuery is the ability to use calculated columns. Calculated columns are typically defined within the data model itself and require the underlying data to be loaded into Power BI. However, with DirectQuery, Power BI does not import the data; it queries the data source directly. This means that any transformations or calculations intended for calculated columns cannot be executed in the same way, as the data remains in the source system and is only updated through queries. On the other hand, while using DirectQuery, you can create new measures as they are evaluated at query time and do not require additional storage in the data model. You can also change data source settings, which allows flexibility when managing connections to your data. Parent-child DAX functions can also be used, provided that the necessary data structures are present in the underlying data source. Therefore, recognizing that calculated columns require the data to be imported into Power BI's data model while DirectQuery operates on a live connection explains why this feature is not available.

In Power BI, when utilizing DirectQuery as the connection mode to your data source, certain limitations are imposed regarding data manipulation within the model. One key feature that is not available in DirectQuery is the ability to use calculated columns.

Calculated columns are typically defined within the data model itself and require the underlying data to be loaded into Power BI. However, with DirectQuery, Power BI does not import the data; it queries the data source directly. This means that any transformations or calculations intended for calculated columns cannot be executed in the same way, as the data remains in the source system and is only updated through queries.

On the other hand, while using DirectQuery, you can create new measures as they are evaluated at query time and do not require additional storage in the data model. You can also change data source settings, which allows flexibility when managing connections to your data. Parent-child DAX functions can also be used, provided that the necessary data structures are present in the underlying data source.

Therefore, recognizing that calculated columns require the data to be imported into Power BI's data model while DirectQuery operates on a live connection explains why this feature is not available.