Identifying Slow queries in Excel PowerPivot
Technorati Tags: PowerPivot,SQL BI,Excel
I had a very slow power pivot report and wanted to identify which query was taking the time so I enabled the tracing
![clip_image001[5]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/45/98/metablogapi/3005.clip_image0015_2270DED5.jpg "clip_image001[5]")
The trace is generated by default in your desktop, the trace is a SQL Profiler trace so you will need to use SQL Profiler to open it.
When is open, organize the columns by eventclass
![clip_image002[4]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/45/98/metablogapi/6153.clip_image0024_16DB2196.png "clip_image002[4]")
Now filter the eventSubclass to 25 which is execute SQL
![clip_image003[4]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/45/98/metablogapi/8306.clip_image0034_7D731E5B.png "clip_image003[4]")
Now you can focus in Progress Report End event and check what TSQL is taking longer
![clip_image004[4]](https://msdntnarchive.z22.web.core.windows.net/media/MSDNBlogsFS/prod.evol.blogs.msdn.com/CommunityServer.Blogs.Components.WeblogFiles/00/00/01/45/98/metablogapi/8540.clip_image0044_66B3D6D2.png "clip_image004[4]")