Forum Discussion
rajuj
7 years agoFrequent Visitor
Data refresh time estimate
Hi folks, I am curious to know the ideal time it takes to refresh and deploy a dataset with 10 million records (Intel Xeon 2.3Ghz 32 GB RAM). Is there any benchmark of the system configuration for th...
- 7 years agoHappy to help!
It can depend on the Gateway Server it is installed on.
As well as the bandwidth you have between your Gateway Server and where your data is hosted.
And also the larger the PBIX the longer it will take to upload the data to the Power BI Service.
GilbertQ
7 years agoSuper User
I have a larger dataset and on Power BI Desktop it takes a few minutes to refresh about 15M rows.
rajuj
7 years agoFrequent Visitor
Thanks for the quick response, much appreciated.
What difference in time it takes if it is Power BI service refresh, for the same dataset? For example, from 5 minutes to 15 minutes?
- GilbertQ7 years agoSuper UserHappy to help!
It can depend on the Gateway Server it is installed on.
As well as the bandwidth you have between your Gateway Server and where your data is hosted.
And also the larger the PBIX the longer it will take to upload the data to the Power BI Service.- rajuj7 years agoFrequent Visitor
That make sense. There are lot of factors involved and no easy way to measure or improve refresh rate while using Power BI service.
Thanks again.
- GilbertQ7 years agoSuper User
There are things you can monitor such as bandwidth and Gateway Server performance to see if there are any bottlenecks there.