Forum Discussion

liushiyou's avatar
liushiyou
Regular Visitor
4 years ago
Solved

Dataset size limit vs Capacity Memory

Hi,   Accordnig to Microsoft document, there are maximum dataset sizes per capacity.  P1 for example, the maximum dataset size is 3 GB.  Also, the memory size for P1 capacity is 25 GB.  My understa...
  • v-henryk-mstf's avatar
    4 years ago

    Hi  liushiyou ,

     

    Not quite accurate, there is another parameter to note, that is, the number of v cores, different P/A sku corresponding to the number of v cores are different.

    • Backend v-cores are responsible for core Power BI functionality, including query processing, cache management, running R services, model refresh, and server-side rendering of reports and images. Backend v-cores are assigned a fixed amount of memory that is primarily used to host models, also known as active datasets.

    So for P1/A4, it supports parallel querying of four queries with a maximum of 8GB of memory, but at most 6 parallel queries.

     

    The understanding of the maximum data set refresh to 12GB is:

    For more details,  you can read related link as below:

    What is Microsoft Power BI Premium? - Power BI | Microsoft Docs

    Solved: premium - MAX size for one dataset - Microsoft Power BI Community


    Best Regards,
    Henry


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