Slow loading times with DirectQuery and Azure

[v-dabatc]

I have a report that is using DirectQuery to interact with an Azure SQL database.  The initial load times for this report vary from 3 seconds, all the way to 45 seconds or more.  When I open up the same report in the Power BI Desktop App, the load and/or refresh times are much less and within an acceptable range - the times are less than 5 seconds.

We're looking to have fast report loading times.  We've pre-aggregated our data, and have a simple select statement when reading the data from Azure.

I'd like to know if anyone else has seen these same slow loading times and/or if there is a way to improve upon the loading times.

[gustavjMC]

Hello, 

It's now been a while (5 years 😂) have you come up with any solutions on this problem? I experience this aswell, the initial load time is very slow compared to load times after the initial load.