Getting the partition name

[Anonymous]

In the context of an Azure SSAS Tabular model table split into month partions for the purposes of refreshing, is it possible for the Power Query (in M language?) to determine the name of the partition it is in?

[Anonymous]

[v-juanli-msft]

Hi @Anonymous 

"Incremental refresh" in Power BI has the similar features with "partition" in ssas.

Please check links below how to create and apply it.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Interesting, but not helpful as we are using Azure SSAS, as I think I mentioned in my post.

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Incremental refresh works for which data source is from SSAS.

Direct query or live connect seems impossible to apply incremental refresh in Power BI.

If my previous suggestions are not helpful,

Please check if the two articles help you.

Creating A Partitioned Table In SSAS Tabular 2017 And SSDT Using M Functions

SQL or M? – SSAS Partitions in Power Query/M

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Sweet, Maggie. Thanks.

Although not able to get the name of the partition, after several cups of coffee to get my head round the article you linked, all the partitions looks like this. A vast improvement.