Forum Discussion
Increase the performance time when using Direct Query
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
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
3 Replies
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/1036016Fowmy : lets assume the source is Azure Synapse and optimised , considering this how much should be the standard response time?
