Where in the question does it say "most efficient" method or concerns regarding the model size? The goal was to import a sample of the data and it was asking: "Does this meet the goal?". Should this not be Yes?
@HybridHedgehog9 күн бұрын
Could it be you were implying that, the table has already been imported before the transformation could be applied, so it's incorrect already?
@HerseyHouseBI9 күн бұрын
The table was loaded into the power query but not the power bi desktop. As a data analyst it is important to always consider efficiency and performance. It does load the entire table first and not just a sample, while a filter transformation would limit the data before loading into the desktop the processing time to apply the transformation across the millions of rows would take much longer than just using a where clause in a sql statement.