How to improve Direct Query SQL Server Performance?

[Anonymous]

Hi everyone.I am new to Power BI and need help with improving the Direct Query performance.The data is almost 2GB.Please suggest ways to improve performance.Thanks in advance.

[Anonymous]

Hi @Anonymous ,

The working principle of DQ is that the PBI sends query requests to SQL, and SQL returns the results to PBI.

On the one hand, you could optimize network transmission efficiency, on the other hand, you could to optimize SQL query efficiency.

Here are the offical document about optimizing data source performance for DirectQuery model
DirectQuery model guidance in Power BI Desktop - Power BI | Microsoft Learn

[NikhilChenna]

Hi @Anonymous ,

How are you usign the data from SQL, directly using the tables or did you create any view from tables and using that as a source. First check how much time it is taking to retrieve data in sql only. it should be less then automatically your BI performance will improve.

Regards,

Nikhil Chenna

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi @NikhilChenna ,

I am using tables directly.

[NikhilChenna]

Hi @Anonymous , Are the tables taking time to load  in SQL ?