Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
S_M
Helper III
Helper III

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 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 ?

2 REPLIES 2
v-caliao-msft
Employee
Employee

@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

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) 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors