Partition limits

[jamat]

Is there a limit to the number of partitions you can have in a Power BI (premium) data model? (Incremental refresh)

Thanks in advance!

[lbendlin · Accepted solution]

This document does not mention any partition limits

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#xmla-endpoint-be...

But what you will find is that Power BI will automatically consolidate partitions the "colder"  the data gets, based on a date hierarchy (months/quarters/years).