Forum Discussion
Using aggregations in sql query or in power bi
If we use aggregations in our sql query side by side with non aggregated data for example the following:
| id | sales | category | total_count | tvs sold by category |
| 1 | 1000 | tvs | 4 | 50% |
| 2 | 1100 | tvs | 4 | 50% |
| 3 | 700 | mobile phones | 4 | 50% |
| 4 | 600 | mobile phones | 4 | 50% |
If I now bring this into power bi and I filter out id # 2 will I still be left with 50% tvs sold by company,
I am getting the data from a database using a native sql query.
What is the best practice in bringing in data into power b should the data be detailed and not summarized and to leave the summarization for power bi using measures.
akhaliq7 , You should bring a detailed table. and try to have measures.
In some case, we bring in both detailed and summarized data to improve performance. But that will be case to case basis
1 Reply
akhaliq7 , You should bring a detailed table. and try to have measures.
In some case, we bring in both detailed and summarized data to improve performance. But that will be case to case basis