Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting the partition name

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 partitio...
Need Help
Tips and Tricks
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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.