Forum Discussion

Aruna_ln's avatar
Aruna_ln
Icon for Helper III rankHelper III
8 years ago

power bi reports very slow

Hi Team, I have 1 crore  records in query(mean after joining 3 tables) my databse is sql server and i am using direct query.   when create report in power bi  very slow query is good or view is ...
Need Help
v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Aruna_ln,

 

To troubleshoot the performance of your report. First we should verify if the poor performance is caused by the measures. Try to remove all the measures and see if the report run fast.

 

After removing the measures, if the report is still running slow. I'm afraid the only effective way to improve the performance is to improve the data structure at SQL Server database side.

 

For this part, you can refer to this article: Performance recommendations for SQL Database

 

If the report runs fast without the measures. Then the issue should be caused by the measures and you have to improve the measures. 

 

Reference: https://community.powerbi.com/t5/Developer/PowerBI-DirectQuery-Performance-with-Measures/m-p/114824

 

Thanks,
Xi Jin.