Skip to main content

Power BI

New

NEW feature : Power query proposes a Slow Change Dimension mechanism

Vote (1) Share
Christophe Hervouet's profile image

Christophe Hervouet on 11 Oct 2022 11:12:08

-Several versions of a key regarding some type 2 columns (start date & end date & index never change)

- Update a row for type 1 updates

  • Power query paradigm will change on this case because MODEL loads will avoid to do delete + insert rows

, but more insert (new version) + update (old version with an end date)