cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rajuj Frequent Visitor
Frequent 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 the volume of the data being used in PBI? 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Data refresh time estimate

Happy 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.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

7 REPLIES 7
Super User
Super User

Re: Data refresh time estimate

Hi there

Is this refresh in Power BI Desktop or via the Power BI Service?

It will also depend on what is your source is.

And then finally also how many data transformations are happening in Power Query?

All of the above could affect the refresh performance.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
rajuj Frequent Visitor
Frequent Visitor

Re: Data refresh time estimate

Powerbi desktop and source is SQL Server.

Its pretty straight forward data 6 dim table and  1 fact table refresh.

Super User
Super User

Re: Data refresh time estimate

I have a larger dataset and on Power BI Desktop it takes a few minutes to refresh about 15M rows.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
rajuj Frequent Visitor
Frequent Visitor

Re: Data refresh time estimate

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?

Super User
Super User

Re: Data refresh time estimate

Happy 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.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

rajuj Frequent Visitor
Frequent Visitor

Re: Data refresh time estimate

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.

Super User
Super User

Re: Data refresh time estimate

There are things you can monitor such as bandwidth and Gateway Server performance to see if there are any bottlenecks there.


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 42 members 888 guests
Please welcome our newest community members: