Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Performance issue while refreshing from Power BI desktop.

I have 54Lakhs records in Power BI report which comes from SQL table. When loaded records first time loaded in 30 min but when I try to refresh report after changes done in desktop it's taking more than 1 hour and after that got stuck at 53Lakhs records. Could you please sugguest me any alternate approach to mitigate this issue.

Issue.PNG

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Shrutika

 

You can limit useful data and visuals, optimize data model to improve performance. Also you can check which query takes long time to execute via SQL profiler. For detail information, you can refer to this document: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

 

Best Regards,
Qiuyun Yu 

Shrutika
Regular Visitor

Hi @v-qiuyu-msft,

 

I am using huge data as I need to show trend for last six months. And this much data is expected for it.

 

Best Regards,

Shrutika

v-qiuyu-msft
Community Support

Hi @Shrutika

 

May I know if the issue is resolved after following my previous suggestion? 

 

Best Regards,
Qiuyun Yu