Santhosh Kumar Alladi on 12 Jul 2022 09:07:25
It has been observed that a Matrix visual with DIRECT mode query in the data model with Totals enabled, is resulting in multiple queries : one SQL for detail rows and another SQL for Totals row. Also, observed that Total SQL is getting triggered only after detail row SQL is fully executed, it's because they are being executed sequentially.
This has ben reported to Microsoft and identified as an issue and also submitted a change request.
However, we have been told to follow the Idea forum path to get more traction and priority.
Hope this idea will be taken with priority and handled.