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 ...
Anonymous - Try implementing aggregation tables perhaps. https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations