Forum Discussion
DAX Table Performance on Model/Report
Hi, I'm contemplating creating a few DAX Tables which and quite lengthy and taking the load of some SQL queries (which are proving to slow the process down somewhat). I know we can time how ...
Not sure if this is possible for you but a possible solution would be to push any transformations back to the data source and bring in aggregated views of the data needed.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thanks for both your replies, it's much appreciated. I'll mark your other answer as an accepted solution. We've pushed calculations back when memory issues have arisen on pages. However in this case the pivoting of large data sets in SQL is terribly slow. And I'm trying to approach this issue either using a DAX table or in Power Query, with the latter please see my other post this morning.
