Forum Discussion
Group vs Table.Buffer
for which I receive periodic updates to individual records. Power Query has no concept of that. The lowest you can go is to do "incremental refresh" which allows you to refresh individual partitions, but still in a flush and fill way.
What you are after is differential refresh, CDC (Change Data Capture) or some variation of SCD (for example SCD2)
To repeat - Power BI by itself does not support any of that - It is you who will have to put in the work to manage the information in a SCD2 table , for example.
The poor man's solution is incremental refresh with a larger "hot" window than what you think you need. But SCD2 is probably the second best least worst option.
Thanks for this that lead me to Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD - BI Insight
This one uses List.Max and Merge, which seems to be useful if you want to continue to use "Column Distribution" The YouTube option blows that away.
