Power BI Direct Query First Load Slowness Problem

[Gurpreetsingh1]

Hi Guys, Hope you are doing well. I am using direct query mode in Power BI and data source is Amazone redshift. While I load first time my report in services my visuals take aprrox 1 mint to load data which is a bad user experince for my client. And after that first load it works fine . So is there any way to improve this so that it can load in 5 to 10 Sec. Please help me solve this problem. Attaching Snapshot for refrence. 

Thanks 

[Akash_Varuna]

Hi @Gurpreetsingh1 You could try to pre agregate the data and optimize queries and use query caching try these please
Optimize Redshift by using pre-aggregated tables, materialized views, proper indexing, and efficient SQL queries. Simplify Dax Measuures

Enable query caching in Power BI Service for faster subsequent loads.

Schedule cache refreshes to pre-load data during off-peak hours.
Utilize Power BI’s Performance Analyzer and Redshift query logs to identify and resolve bottlenecks.
If this post helped please do give a kudos and accept this as a solution 
Thanks In Advance

[Gurpreetsingh1]

Hi @Akash_Varuna thanks for the reply i have done all these steps, Optimized my report, enable query caching and reduce date range (for a week), But still it takes approx 40-50 seconds to load data into visuals. Don't know its problem with direct query mode or it is the usual connection time b/w Power bi and source.

[v-achippa · Accepted solution]

Hi @Gurpreetsingh1,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Akash_Varuna for addressing the issue.

Since you have already optimized the report and enabled query caching, the main issue is likely the nature of DirectQuery mode and its connection to Amazon Redshift.

DirectQuery introduces some latency as it executes live queries on Redshift instead of caching data in Power BI. Redshift is optimized for batch processing rather than real-time queries, DirectQuery doesn't work as efficiently with it as it does with SQL Server or Snowflake.

Additionally, connection overhead between Power BI and Redshift can cause delays, especially on the initial load. While caching helps with subsequent queries, some level of latency is expected, especially in reports with multiple visuals querying live data.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Gurpreetsingh1,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Gurpreetsingh1,

We wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @Gurpreetsingh1,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked.
If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa