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 r...
cube
DAX Measures
SSAS
SSAS CUBES POWERBI MEASURES
  • lbendlin's avatar
    lbendlin
    2 years ago

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

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?

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

      Same answer - use DAX Studio