question

David-4306 avatar image
0 Votes"
David-4306 asked David-4306 answered

Tabular SSAS/AAS Partitions

Hi! I'd like to ask for some help with something. I have a large tabular model originally developed on SSAS standard (does not support partitions). The data model has since been migrated to AAS S1 (does support partitions). I've found it necessary to partition several tables but I have been unable to. If I attempt to create a new partition on any table I get the error "You cannot create a new partition for this table. The deployment server is running a SQL Server edition that doesn't support more than one partition for each table. Please make sure there is only one partition in this table."

If I create a new project and define some tables I am able to create partitions on AAS.

I'm very confused...why doesn't my existing project recognize that partitions are allowed on AAS? Please help and thank you!

azure-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

dgosbell avatar image
0 Votes"
dgosbell answered

Right click on your project in the Solution explorer in Visual Studio. Then in the deployment settings make sure the server edition property is set to "Enterprise". It sounds like you have this set to "Standard" and this will prevent you from using features that are not supported by Standard

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered

Hi,

How have you migrated the project?

Check the bim file in you project , see if you could find any edition related keyword like "standard" or "edtion" in bim file.
If not you could just copy paste the bim file content in a new created AAS project.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

David-4306 avatar image
0 Votes"
David-4306 answered

Hi @dgosbell. That was exactly the problem. Thank you!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.