This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Has anyone used Table.Partition() in a dataflow or report? I am looking for a use case that demos any performance improvement from using this M function. I can't find anyone utilizing it in an online discussion or video.
That use case seems particularly weak. The comment theread is more interesting though. I gues I'm trying to understand whether there are certain merges or functions that perform better when the data is partitioned and operations are run in parallel.
In my mind, it doesn't seem that different from Group By using the All Rows aggregation. So I wouldn't really expect it to unlock unique performance gains compared to that more-common operation.
Chris Webb suggests creating histograms as a potential use case.
https://blog.crossjoin.co.uk/2014/10/07/creating-histograms-with-power-query/
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |