Identify DAX Measures consuming too long to process

[MAli_Ch]

I have a tabular model on Visual Studio where data size is normal. It use to take 35-40 min to refresh 1 month back but someone added/modified few DAX Measures. Since then it is taking too long too refresh data. I want to indentify measures which are causing this issue. I have used these measures in Power BI reports too. How can I findout these measures so my model can be efficient and start refreshing normally.

[lbendlin · Accepted solution]

Connect DAX Studio to your tabular model and check the Query plan and Server Timings for these measures.

[MAli_Ch]

Also I need to know that can my partitions be slow due to data fetching is taking place from a view which has a quite complex query and mulitple joins?

[lbendlin]

Same answer - use DAX Studio 

[MAli_Ch]

Hi @lbendlin, thanks for responding. I want to know one more thing here that I have few calculated columns inside my tabular model I want to evaluate those too. How can I perform testing on it?