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

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

  • 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.