Forum Discussion

S_M's avatar
S_M
Helper III
9 years ago

Trace problematic queries for report refresh ?

Hi,    I wanted to know, is there a way i can (other than the PBI Trace) check for what queries in my report are causing the data refresh to take long, so that i can optimize accordingly ? Just som...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

S_M,

 

Which data source are you connected? As you said that "i have 2 models which are reading from 2 different datasets", those 2 datasets connect to the same data source server? You need to ensure that all other influence factor are the same when comparing two datasets' performance.

 

If you connect to SQL Server database, you could use SQL profiler to identify slow runing query, please refer to the link below to see the details.
https://www.simple-talk.com/sql/performance/how-to-identify-slow-running-queries-with-sql-profiler/

 

Regards,

Charlie Liao

  • S_M's avatar
    S_M
    Helper III
    9 years ago

    Hi v-caliao-msft, 

     

    Sorry for not being clear around it - the 2 models are reading data my MYSQL using ODBC connectors - while the dataset is different, they are both connected using ODBC from the same MYSQL db, and are structured the same way. Model B is sized slightly larger than Model A, but not enough to account for a difference of about 15mins in refresh time (think of the 2 datasets used for Model A and Model B as being the same / alligned except the size of the data wherein one is ever so slightly larger than the other)