Forum Discussion
Possibility to call data from DB only when drillthrough
Hi All,
I have a matrix which presenting the summary for each item as below: the number here is the complex calculation using the other indicator 1, 2 ,3.
When users want to see the details of this summary, they can drill through to another page for the status of indicator 1, 2, 3, as below
To reduce the time loading data from DB, wondering if it's possible to only call out indicator 1, 2, 3 from DB when users click for drillthrough. Like here, only when user clicks on Supplier > QUAIL ELECTRONICS, then call out the data in DB that belongs to the critiera. So when users open PBI dashboard, no need to spend time loading all data
Thanks in advance for any suggestion!
1 Reply
- mwegener
Most Valuable Professional
Hi Anonymous ,
check aggregations.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
Configure Power BI Aggregations
https://www.youtube.com/watch?v=kytYzjTXUHs
Why can't I define my Power BI Aggregations???
https://www.youtube.com/watch?v=V9aG-6wr1xQ
Are you HITTING your Power BI aggregations???
https://www.youtube.com/watch?v=ivWGSnthTDw
Using Precedence to force Power BI Aggregations
https://www.youtube.com/watch?v=VPTpRyzV2-A