Query to get a list of Paritions

grajee 346

All,

Would the DMV -- $SYSTEM.TMSCHEMA_PARTITIONS -- on AAS give me a list of Partitions in a Analysis Service Tabular Model database?

We are trying to see if the "Basic Tier B1/B2" Pricing Tier would help us get more value for the same price of that of S0/S1 Pricing Tier.

Thanks,
grajee

HarithaMaddi-MSFT 10,136 Reputation points

2020-10-09T15:35:36.027+00:00

Hi @grajee ,

We have not received a response from you. Please let us know if below answer from @Lukas Yu -MSFT is helpful. Otherwise, let us know and we will continue to engage with you on the question.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
HarithaMaddi-MSFT 10,136 Reputation points

2020-10-12T05:22:14.257+00:00

Hi @grajee ,

We still have not heard back from you. Following up to check if below answer from @Lukas Yu -MSFT is helpful. Otherwise, let us know and we will continue to engage with you on the question.

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Accepted answer

Lukas Yu -MSFT 5,821 Reputation points

2020-10-08T01:32:09.05+00:00
Hi,

According to Rowsets described : SQL Server Analysis Services Tabular Protocol
This code :

SELECT [Name] FROM $SYSTEM.TMSCHEMA_PARTITIONS

could work in AAS or SSAS on-prem as you want.

Regards,
Lukas

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

2 people found this answer helpful.

0 comments No comments
Sign in to comment

0 additional answers