Forum Discussion

Bebs's avatar
Bebs
Helper II
2 years ago

Matrix Table memory limitation

Hello,

I've read in the forum that Matrix table have a limit to 1Go of memory.

 

Is this limit true and still applying today ?

Will this limits still apply in big PowerBI Cloud hosting ?

Is there any way to parameter PowerBI to extend this limit ? (I'm thinking for PowerBI Desktop or in Cloud) ?

 

 

Thanks for your help 😉

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Bebs 

    There are the following limitations for Matrix:

    Large semantic models, data point limits, and data strategies - Power BI | Microsoft Learn

    Additionally, you might consider using a 64-bit version of Power BI, which will allow you to use more memory:

    Because metrix are calculated dynamically, they consume the processing power of the CPU and also consume temporary memory, so when the number of columns or rows in a matrix/table exceeds the limit, the memory limit is exceeded. As you can see in the following blog, how matrix consume memory to the point that there is this memory limit:

    Why my Power BI Matrix or Table Visual is SLOW - RADACAD

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

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