Forum Discussion
Resolver IIISlow update through Gateway on premises
Dear all,
Curently when i am updating my PBI data in powerbi desktop need around 3 minutes.
When i publish this file and trying to update in PowerBi Service , it require more than 15 minutes.
Any solution on that ? ( i have pro licence , not premium capacity)
Thanks in advance
That's quite a report. The best way to make it faster and smaller is to downsize it. You can search for practices to do that, there are a lot, you can check this post. Those are my 5 favourites:
https://blog.ladataweb.com.ar/post/614108758904389632/datamodeling-5-tips-de-reducción-de-tamaño-de
Another recommendation as a governance stand point. You can improve the flow with the good practice to separate the dataset from the report like the following video. This shouldn't change a lot the refresh speed but you will be able to work in reports without waiting for a new refresh each time you publish the report. It will also help some downsize because 40 pages is a lot. You can follow the video to get the practice.
https://www.youtube.com/watch?v=gmbihm3QsaI
Hope thath helps,
4 Replies
- ibarrau
Super User
Hi. If your desktop is connecting an on premise data, then it is travelling in local network. That is very fast because the only time you need to respond it's the query time. When you configure Power Bi Service, you need to upload the data to the Service through the gateway. That depends on your upload bandwith and query time. You might want to check your upload speed when publishing to understand if you should increment your internet speed to improve this.
You can also check for best practices to improve and downsize your data model.
Hope that helps,
- SpiroswayGR
Hey , thanks for your reply.
We just checked upload speed when pbi refreshed but the max upload was around 30Mbps and my capacity is 200Mbps (though optical fiber).
I am working on that to decreasethe size cause is around 126mbyte compressed (40 reports pages) with 1000+ measures + 100 calculated columns).
- ibarrau
That's quite a report. The best way to make it faster and smaller is to downsize it. You can search for practices to do that, there are a lot, you can check this post. Those are my 5 favourites:
https://blog.ladataweb.com.ar/post/614108758904389632/datamodeling-5-tips-de-reducción-de-tamaño-de
Another recommendation as a governance stand point. You can improve the flow with the good practice to separate the dataset from the report like the following video. This shouldn't change a lot the refresh speed but you will be able to work in reports without waiting for a new refresh each time you publish the report. It will also help some downsize because 40 pages is a lot. You can follow the video to get the practice.
https://www.youtube.com/watch?v=gmbihm3QsaI
Hope thath helps,
