Question

A financial reporting model imports a 60-million-row fact table. Refreshes are slow and the .pbix file is very large. Using DAX Studio's VertiPaq Analyzer, you find that a single column, OrderDateTime (stored as date/time with second-level precision), consumes the largest share of model memory. Reports only ever aggregate sales by day, month, and year — never by time of day. Which action reduces model size while preserving all required reporting capability?

Accepted Answer

Change the OrderDateTime column's data type to Date so the time portion is dropped, collapsing distinct values.

Answer

Set the OrderDateTime column's Summarize By property to Do Not Summarize.

Answer

Hide the OrderDateTime column from Report view so it no longer loads into memory.

Answer

Switch the fact table's storage mode to DirectQuery to avoid importing the column.