Forum Discussion
Matrix Performance issue in Direct query
Hi Team, I've used the matrix visual in direct query model, since it fires the query at each level of the hierrachy. For Example: Matrix visual shown SUM(Sales) by Date and Region The actual ...
hi Anonymous
In directquery mode in power bi, there is no data in dataset, so each interaction or adjust in visual filed, it will send a query to datasource, not only in matrix visual, all the visuals have the same logic.
https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
Regards,
Lin