Solved: Partition limits

jamat · ‎10-02-2020

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 · ‎10-02-2020

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).

View solution in original post

lbendlin · ‎10-02-2020

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).