Trace problematic queries for report refresh ?

Question

Hi,&nbsp;&nbsp;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 · Answer

S_M,
&nbsp;
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&nbsp;influence factor are the same when comparing two datasets' performance.
&nbsp;
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/
&nbsp;
Regards,
Charlie Liao

s_m · Answer

Hi&nbsp;v-caliao-msft,&nbsp;&nbsp;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)&nbsp;

Forum Discussion

Trace problematic queries for report refresh ?

Related content

Refresh Direct Query not refreshing

Excel Power Query Refresh

Refresh Query automatically Excel PowerQuery

Power BI fails with custom delimiter '^|' , how to identify problematic row?

Queries Won't Refresh