Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
Interesting, but not helpful as we are using Azure SSAS, as I think I mentioned in my post.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.