Skip to main content

Power BI

New

Implement Parallel Queries for DIRECT mode in Matrix Visual

Vote (7) Share
Santhosh Kumar Alladi's profile image

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.