Question

You import a large Sales table into Power BI. The Quantity column is stored as a Decimal Number type, but every value in the source is a whole number with no fractional part. During profiling you notice the model size is larger than expected. Which single Power Query action best reduces the storage footprint of this column while keeping the data valid?

Accepted Answer

Change the Quantity column data type to Whole Number (Int64).

Answer

Change the Quantity column data type to Fixed Decimal Number (Currency).

Answer

Round the Quantity column to zero decimal places but keep the Decimal Number type.

Answer

Set the column's Value Type property to Text to compress repeated values.