Data Refresh too slow...

[Sadath]

Hi All,

Power BI data refresh (sheduled refresh or manual refresh) takes more than 45 min.

All my data is in Excel file and stored in One drive.  Main table having only approx 120k rows. 

Is it takes takes this much time to refresh ?. Or any way to speedup data refresh.

Thanks

[v-lili6-msft]

hi  @Sadath 

Is your gateway the latest version? Probably check if your gateway machine run out of disk/memory?Make sure that it has got enough memory, CPU and bandwidth to both the source data and Power BI service.

Regards,
Lin

[amitchandak]

@Sadath , refer if these can help

https://www.thebiccountant.com/speedperformance-aspects/

Also refer

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-The-Do-s-and-Don-ts-of-Power-BI-Rel...
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-sho...