Best pratices for data modeling

I was wondering what is the best option when you load a table and build your model to use in PowerBi:

- To get the entire table you need;

Example:

Product | Value | Quantity sold | Total sales

      x        1,00             3                3,00

- Ignore some columns of the table you need, considering you can use measure to obtain the same values so you bring only few necessary columns;

Product | Value | Quantity sold

      x        1,00             3        

Use a measure to get the total sales.

- Use Stored procedure and SQL to bring everything you need (Power Query?);

SELECT Product=x, where value=1,00.... etc

I know calculated column is out of question, I'm not considering it.

Thanks

Daniel