cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashmozzart Frequent Visitor
Frequent Visitor

Poor performance when direct querying to an Azure SQL DW

Hi,

I am connecting to Azure sql datawarehouse using Direct Query with 2 million records in the fact table.My reports are performing too slow.The report is taking 2 minutes to load.When we apply any slicers it is taking more than 1 minute.Please suggest me how to improve the performance of the reports?

 

Thanks in Advance,

Ash

1 REPLY 1
Community Support Team
Community Support Team

Re: Poor performance when direct querying to an Azure SQL DW

Hi @ashmozzart,

 

I think you should improve your data structure at azure database side, I haven't found some effective solutions to improve the performance at power bi desktop side.


You can also take a look at below links which about improve performance:

How to Improve Query Reference performance for large tables

Improve columnstore index performance in Azure SQL

Performance recommendations

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |