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;
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.
Go to Solution.
You may take a look at https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/.
View solution in original post
https://powerbidatamodel.com/powerbi/power-bi-data-modeling-best-practices/ @danielsouza i hope this helps
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.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!