Forum Discussion
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...
I completely agree lbendlin and smpa01 . Just ran the view again in SQLServer. Took 23 minutes. But we are planning to add an index. The main issue for now is that I get that SQL Profiler error. So I can't get insights in why it takes so long.
Furthermore I will dive into bootstrapping. Never heard of it 🙂
