Best pratices for data modeling

[danielsouza]

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

[v-chuncz-msft · Accepted solution]

@danielsouza,

You may take a look at https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/.

[danielsouza]

Thank you so much guys!

I conclude that the best way is to obtain the minimal data I need, and use maximum of PowerBI measures.

[Hardik · Accepted solution]

https://powerbidatamodel.com/powerbi/power-bi-data-modeling-best-practices/ @danielsouza i hope this helps

[v-chuncz-msft · Accepted solution]

@danielsouza,

You may take a look at https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/.