Forum Discussion

mmossel's avatar
mmossel
Microsoft Employee
3 years ago
Solved

Does Autoscale increase model refresh parallelism?

Hi,
 
When Autoscale adds extra v-cores, does it also increase model refresh parallelism (mrp)? E.g. two v-cores gives 10 extra mrp?

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi mmossel ,

     

    When you increase the number of v-cores by autoscaling, you can improve the overall performance of your model by providing additional compute resources. The maximum number of parallelism is increased, however, it does not cause the refresh parallelism to increase proportionally.

    Please refer to the following documents for more information.

    Chris Webb's BI Blog: Increasing Refresh Parallelism -And Performance – In Power BI Premium (crossjoin.co.uk)

    Increasing Refresh Parallelism in Power BI Premium – Curated SQL

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

     

    • mmossel's avatar
      mmossel
      Microsoft Employee

      Anonymous these blog posts refer to refresh parallelism inside of Power BI Desktop, so the effect is on one model. I am not referring to this. I am referring to model refresh parallelism in the Power BI Service, i.e. how many Power BI Datasets can be refreshed at the same time. 

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi mmossel ,

         

        As far as I know, there is no upper limit for parallel refreshes for Premium capacity as long as your capacity CPU does not exceed the limit.

         

        Best Regards,

        Neeko Tang

        If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.