Trace problematic queries for report refresh ?

[S_M]

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 some context, i have 2 models which are reading from 2 different datasets - however, they are more or less structured the same way, but Model A takes about 6-8 mins to refresh and publish, whereas Model B takes about 25mins for the same. Any help ?

[v-caliao-msft]

@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]

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)