Warm tip: This article is reproduced from stackoverflow.com, please click
azure ssas partition

SSAS limited to one partition

发布于 2020-03-29 20:57:44

I have SSAS model (tabular) on Azure and I'm trying to add a partition to a table. When I try to deploy my solution, I get the following error message :

Failed to save changes to the server. Error returned: "This edition of SQL Server Analysis Services supports only one partition per table."

How do I configure the number of partition allowed ?

Questioner
kalupso
Viewed
39
kalupso 2020-01-31 18:05

I found the solution : the problem was the pricing of my Azure Analysis Service. I switched it from Basic tier B2 to Standard tier S1. I am now able to use multiple partitions.