Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Memory allocation

Hi I would like to confirm if there is the limit of the memory consumption of a single Power BI item for Shared capacity workspaces as well. What is it.

 

I also want to know the reason why set this limit for premium workspaces eg. improve performance or any other reason .

Sorry I did not find related articles.

 

 

With Premium Gen2 and Embedded Gen2, the amount of memory available on each SKU is set to the limit of the memory consumption of a single Power BI item. 

What is Power BI Premium Gen2? - Power BI | Microsoft Learn

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    As you can see in the note below:

     

    3 The Max memory per dataset (GB) column represents an upper bound for the dataset size. However, an amount of memory must be reserved for operations such as refreshes and queries on the dataset. The maximum dataset size permitted on a capacity may be smaller than the numbers in this column.

     

    And Shared capacity has size limits of 1 GB per dataset. So memory limit for Shared capacity is 1 GB per dataset too.

     

    Best Regards,

    Jay

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Shared capacity has limits of 1 GB per dataset, 10 GB per user and eight refreshes per day

     

    Best Regards,

    Jay

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Anonymous 

      Thank you for your reply.

      I meant the Max memory per dataset like the following, what is the limit for Shared capacity.

      Please also kindly tell the benifits of Memory allocation.

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous ,

         

        As you can see in the note below:

         

        3 The Max memory per dataset (GB) column represents an upper bound for the dataset size. However, an amount of memory must be reserved for operations such as refreshes and queries on the dataset. The maximum dataset size permitted on a capacity may be smaller than the numbers in this column.

         

        And Shared capacity has size limits of 1 GB per dataset. So memory limit for Shared capacity is 1 GB per dataset too.

         

        Best Regards,

        Jay

    • Anonymous's avatar
      Anonymous
      Not applicable

      HI Anonymous 

      Could you please kindly tell if storage limit = capacity limits?

      Please kindly help to check the table I listed as below, Is there any mistake?

      Why no per-user storage limit for Premium capacity workspaces, but the total limit is 100 TB, should it be no limit or can’t exceed the storage limit of 100 TB. It will be appreciated if you could explain.

       

      License

      Shared capacity workspaces

      Total : 10GB

      Premium  capacity workspacesTotal : 100TB
        
      Free?No per-user storage limit
      ProTotal usage can’t exceed the tenant storage limit of 10 GB multiplied by the number of Pro licenses in the tenantNo per-user storage limit
      Premium Per User (PPU)100 TB storage limitNo per-user storage limit