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,282 questions
{count} votes

Accepted answer
  1. Azar 22,860 Reputation points MVP
    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 No comments

2 additional answers

Sort by: Most helpful
  1. Olaf Helper 44,501 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 No comments

  2. Pinaki Ghatak 4,285 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 No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.