cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danielsouza
Helper III
Helper III

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

2 ACCEPTED SOLUTIONS
v-chuncz-msft
Community Support
Community Support

@danielsouza,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hardik
Continued Contributor
Continued Contributor
3 REPLIES 3
danielsouza
Helper III
Helper III

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
Continued Contributor
Continued Contributor
v-chuncz-msft
Community Support
Community Support

@danielsouza,

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors