Increase the performance time when using Direct Query

[sp1]

Hello All,

My Power BI report takes almost three minutes to load whole data because I used direct query to get real-time data. My report also contains many visuals. Therefore, I need to improve the performance of my report. 

Can you please suggest a way to improve the performance of PowerBI reports with real time data?

Thank you

[Fowmy · Accepted solution]

@sp1 

If you are connecting on DQ, then you need to have a well-optimized data source as the queries are directly sent to the source.

Please check on the following reply for more information and links: 
https://community.powerbi.com/t5/Desktop/Using-Direct-Query-my-pbix-is-extremely-slow/td-p/1036016

[powerbiexpert22]

@Fowmy : lets assume the source is Azure Synapse and optimised , considering this how much should be the standard response time?

[sp1]

Thank you @Fowmy for your help!