Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Shrutika

Performance issue while refreshing from Power BI desktop.

Submitted by on ‎04-04-2019 03:54 AM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎04-09-2019 06:35 PM

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
‎04-16-2019 05:28 AM

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
Community Support
‎04-19-2019 01:18 AM

Hi @Shrutika, 

 

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

 

Best Regards,
Qiuyun Yu 

Idea Statuses