Share via

error message om ssas

Ziya Scarlet 20 Reputation points
2024-01-17T15:22:15.48+00:00

In my SSAS im getting the below message Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. any suggestions on how to fix this?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,248 questions
Accepted answer
  1. Azar 19,410 Reputation points
    2024-01-18T07:04:48.4233333+00:00

    Hi again thanks fpr letting know, if you could provide the resolution it would be great and ill convert my comment to answer you ca accept if it helped you.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,006 Reputation points
    2024-01-17T19:43:29.1233333+00:00

    Azure or on-premise SSAS? Only Enterprise Editions supports more then one partition.

    0 comments
  2. Pinaki Ghatak 2,400 Reputation points Microsoft Employee
    2024-01-18T14:47:00.3466667+00:00

    Hello @Ziya Scarlet The error message you received indicates that you have exceeded the maximum number of partitions in a measure group. According to the Microsoft documentation, the installed server edition allows not more than 3 partitions and not more than 1 writeback partition. If you have the Enterprise edition of SSAS, you can have no more than 2^31-1 = 2,147,483,647 partitions in a cube. To fix this issue, you can try reducing the number of partitions in your measure group. You can also consider upgrading to the Enterprise edition of SSAS if you haven’t already. I hope this helps!

    0 comments