Forum Discussion
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 partition it is in?
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.
5 Replies
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.