Power BI Direct query Slowness solution / Power BI Direct query First load slowness Solution

[Gurpreetsingh1]

Hi everyone,

I hope you're doing well.

I’ve recently found a solution to speed up the DirectQuery load time and improve the first-load performance of reports. After optimizing the DAX queries and limiting the data at the Power BI level, I discovered that Power BI Service has a session timeout of 60 minutes if there is no interaction with the report. If a user tries to load the report after this session time (e.g., the next day), it takes a longer time to load due to the reconnection process between Power BI and the data source, which can take 15-20 seconds.

To speed this up and make it load instantly, I’ve opened all my reports in Power BI Service on a virtual machine (VM) in a browser and used a Chrome extension for auto-refresh with a set interval of 1000 seconds. This ensures that the connection between Power BI and the data source doesn’t break, and the reports now load much faster for all users. Additionally, I’ve made sure to simulate mouse clicks on the VM to prevent it from going to sleep.

You can also open one report across multiple pages so that if one process stops, the others continue running. This has greatly improved the user experience, and I hope you find this trick helpful as well.

Thanks.

[Anonymous · Accepted solution]

Hi @Gurpreetsingh1 
Thank you for sharing your innovative solution to improve the DirectQuery load time in Power BI Service.Your solution is a valuable contribution to the community, and I'm sure many users will benefit from it. Keep up the great work, and thank you for sharing your insights!
please Accept it as a solution .This will be helpful for other community members who have similar problems to solve it faster.
Thank you