We can improve report performance in Reporting Matrix/Writeback Matrix by disabling Native Total/Subtotal calculations in the backend. While we can disable totals by going to Totals tab the Total/Subtotal calculation will still be calculated in the backend by Power BI:
Therefore, we have an option to disable the Total/Subtotal calculation from Power BI API itself so that it will not be calculated in the back end. This will make the visual faster and improve report performance.
To do this please follow the below steps.
1) Go to Display tab -> Hierarchy -> Native Totals -> Disable Row Total/Subtotal and Column Total/Subtotal:
2) Next go to Insert Tab -> Aggregation -> And change Measure and Hierarchy to Native:
3) Now we can see the Total and Subtotal values have been disabled in the backend:
FAQs:
If we disable Totals under Total in Home tab, will it stop the backend calculation in Power BI and improve performance?
No, it will not. We need to disable the Native Totals in Display tab and set the Aggregation to Native as shown in the blog otherwise the backend calculation will still happen in Power BI.
If we Hide Totals in Home tab, will it stop the backend calculation in Power BI and improve performance?
No, it will not. As mentioned in the blog we need to disable the Native Totals in Display tab and set the Aggregation to Native else the backend calculation will still happen in Power BI.
What is the purpose of disabling Native Total calculation in Inforiver?
To improve report performance and make the visual faster.
