Forum Discussion

Accelins's avatar
Accelins
Frequent Visitor
3 years ago
Solved

Table Visual timeout across multiple dimensions

Hello,  I'm having issues adding multiple dimension columns into a table visual - I have built a star schema (shown in the picture), and when I add in a 2nd dimension my table times out. I'm using...
Need Help
  • Accelins's avatar
    Accelins
    3 years ago

    Ended up changing some of the model fct and dimensions to achieve optimal performance 

Accelins's avatar
Accelins
Frequent Visitor
3 years ago

I always try to avoid any iterators but I also did try FILTER instead of CALCULATETABLE but it returned the same result - table timeout. 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Use DAX Studio to examine the query.