Forum Discussion

MAli_Ch's avatar
MAli_Ch
Regular Visitor
2 years ago
Solved

Identify DAX Measures consuming too long to process

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.

cube
DAX Measures
SSAS
SSAS CUBES POWERBI MEASURES

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

    • MAli_Ch's avatar
      MAli_Ch
      Regular Visitor
      2 years ago

      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?

    • MAli_Ch's avatar
      MAli_Ch
      Regular Visitor
      2 years ago

      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?