Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You may take a look at https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/.
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.
You may take a look at https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |