Forum Discussion
SSAS Tabular Model performance Issue
Thanks for lbendlin's concern about this issue.
Hi, MAli_Ch
Since the increase in refresh time occurs at the same time as the addition of new DAX Measure, it is possible that some Measure are more computationally intensive. You can review these DAX Measure to see if there is room for optimisation. Consider whether certain Measure can be pre-computed during the ETL process rather than in the model.
Try to avoid using Calculated columns or Calculated tables, as they are calculated during processing and may increase refresh time.
Monitor resource usage during processing to see if any limits are reached. You can also use SQL Server Profiler or Extended Event Trace to track processing events. This can help you understand how time is being consumed during processing.
If you are refreshing only the current data, be sure to use the Process Add operation instead of Process Full. Process Add is more efficient when adding new data without reprocessing the entire model.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.