get Partition list in Tabular

Question

Hi!

How can I get a list of Partitions in Analysis Service?

I'm using Tabular.

Could anyone help me?

Answer 1

Hi @PPN

You can try this.

SELECT   
    [Name]   
FROM $SYSTEM.TMSCHEMA_PARTITIONS

Refer to this for more information.

https://learn.microsoft.com/en-us/analysis-services/instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services?view=asallproducts-allversions#rowsets-described-in-the-ms-ssas-t-sql-server-analysis-services-tabular-protocol

Best regards,

Percy Tang

Answer 2

SSAS has some DMV providing the wanted informations

See Dynamic Management Views (DMVs) => TMSCHEMA_PARTITIONS