Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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/
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 7 | |
| 5 | |
| 5 | |
| 5 | |
| 4 |