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.
Hi,
I have a report requirement which has premium as well as loss data. The premium base table has around 400 million records historically and the loss base table has around 5 million records. There are some filters and WHERE conditions on the tables which would limit the number of records.
I have a main SQL query for the main report with 4 sub-queries under it (i.e. 4 select statements using UNIONALL)
1. QTD calculations for Loss
2. ITD calculations for Loss
3. QTD calculations for Premium
4. ITD calculations for Premium
From a performance perspective, I wanted to know on what would be the best practice to create the dataset i.e a single master dataset would be better or having 4 separate datasets (2 for premium and 2 for loss).
I was thinking having 1 dataset would give the user the flexibility of using just 1 report and view data for premium and loss both int he same report but not sure on the performance part, hence any advice or inputs would be appreciated.
Regards,
Vishy
Solved! Go to Solution.
Refer, if this can help
Refer, if this can help
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 |
---|---|
98 | |
96 | |
84 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |