cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cwc52 Frequent Visitor
Frequent Visitor

DirectQuery Initial Queries For Online Report Longer Execution Times

Hi,

 

I have created a report that pulls from a few different Postgres tables to show various traffic information. It shows information within a previous four-hour and next-four hour window from the current time. There are 10 queries that are executed on six tables. There are no aggregations or calculations for these queries, but this data is updated every couple of minutes (as the time changes).

 

If I have not opened this report for several hours, it takes about 15 seconds to query all of the data, but every data refresh after that only takes about two seconds if the report is left open.

 

My question is what is the difference between those two queries? Running the queries on my local SQL client takes about four seconds, so I'm trying to understand what contributes to the longer execute time on that initial query vs. the subsequent queries.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: DirectQuery Initial Queries For Online Report Longer Execution Times

HI @cwc52 

 

Follow this blog to install the dax studio

 

then connect the opened pbix file in dax studio

11.PNG

 

open server timing, run the query

12.PNG

 

or you can use the Performance Analyzer in the Power BI Desktop, please refer to this document:

https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: DirectQuery Initial Queries For Online Report Longer Execution Times

HI @cwc52 

 

Follow this blog to install the dax studio

 

then connect the opened pbix file in dax studio

11.PNG

 

open server timing, run the query

12.PNG

 

or you can use the Performance Analyzer in the Power BI Desktop, please refer to this document:

https://docs.microsoft.com/en-us/power-bi/desktop-performance-analyzer

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors