Which two actions should you perform?

You have a Fabric tenant that contains a semantic model named Model1. Model1 uses Import mode.

Model1 contains a table named Orders.

Orders has 100 million rows and the following fields.

You need to reduce the memory used by Model! and the time it takes to refresh the model.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.
A . Split OrderDateTime into separate date and time columns.
B . Replace TotalQuantity with a calculated column.
C . Convert Quantity into the Text data type.
D . Replace TotalSalesAmount with a measure.

View Answer

Answer: B, D

Explanation:

To reduce memory usage and refresh time, splitting the OrderDateTime into separate date and time columns (A) can help optimize the model because date/time data types can be more memory-intensive than separate date and time columns. Moreover, replacing TotalSalesAmount with a measure (D) instead of a calculated column ensures that the calculation is performed at query time, which can reduce the size of the model as the value is not stored but calculated on the fly.

Reference

= The best practices for optimizing Power BI models are detailed in the Power BI documentation, which recommends using measures for calculations that don’t need to be stored and adjusting data types to improve performance.