Forum Discussion

RvdC's avatar
RvdC
Frequent Visitor
5 years ago

Problem performance with a simple DAX measure in MS Analysis Services

I have a performance problem using a simple DAX measure:

 

MAX('tablename'[DateTimecolumn]).

 

In the tabular model, the DateTimecolumn is part of a hierarchie.

There are about 18.000 records in the table.

 

It takes the measure minutes to show the results. In PowerBI desktop there is no problem at all, also with large datasets. Within one second, results are shown.

 

What can be the cause of this and what can we do to get the same speed as with Power BI desktop?

 

Rob van de Coevering

No RepliesBe the first to reply