Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX Studio and SQL profiler

Hi, I ran a refresh of a dataset  for the first time. It took 4.5 hours.  The main query in this is a view in SQLServer, being an aggregate on a table. When I run this view in SQLServer it takes 40...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thnx, is on my read list. Is there something else then SQL Profiler to get insight in why refreshing takes so long?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Use SSMS and examine the actual query execution plan. It will even suggest indexes for you.