Bernat Agulló on 13 Jan 2021 16:59:23
Power BI relies on having all data in origin, and that's not always the case. With operative systems, often only current values are available, but you may need historic perpective on them. It would be cool to "enable historification" so that at each refresh it adds a new "photo" of the table(s) with a different timestamp on the generic "Photo Timestamp" column that all such datasets would have. It would be even better if you could define the policy for keeping fotos for different time spans (e.g. last year, all photos, previous year, one photo per week, before that one per month... and so on)
It would completely destroy the need for a SQL Server process completely in many use cases