Forum Discussion

rajuj's avatar
rajuj
Frequent Visitor
7 years ago
Solved

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? 

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

7 Replies

  • 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.
    • rajuj's avatar
      rajuj
      Frequent Visitor

      Powerbi desktop and source is SQL Server.

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

      • GilbertQ's avatar
        GilbertQ
        Super User
        I have a larger dataset and on Power BI Desktop it takes a few minutes to refresh about 15M rows.