Forum Discussion
powerbi refresh takes long time
I have a connection to azure sql database. When I make refresh on my desktop it makes refresh in 10-15 minutes. The same refresh on the service takes 1-1,5h.
Azure SQL reports the high consumption of IO during the refresh.
I have an incremental refresh enabled - the issue is mainly about the first refresh after republishing the report.
The dataset size is 878 MB. Can you help me fixing this?
1 Reply
- ibarrau
Super User
Hi there. If this is taking long time I would recommend analyze the model to downsize it. You can check this tips from this blog or any other with downsizing techniques:
https://blog.ladataweb.com.ar/post/614108758904389632/datamodeling-5-tips-de-reducción-de-tamaño-de
In addition you can check the following video from guy in a cube that shows how to prevent a full complete refresh with incremental refresh to control the partitions. It's awesome.
https://www.youtube.com/watch?v=5AWt6ijJG94
Hope that helps,
