DirectQuery Initial Queries For Online Report Longer Execution Times

[Anonymous]

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.

[v-diye-msft · Accepted solution]

HI @Anonymous 

Follow this blog to install the dax studio

then connect the opened pbix file in dax studio

open server timing, run the query

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