Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Problem performance with a simple DAX measure in MS Analysis Services

I have a performance problem using a simple DAX measure:




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


Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors