Wouter De Raeve on 12 Sep 2017 21:17:45
Currently the Power Query Unpivot functionality has the behaviour that if all values in the selected columns are 'null', the resulting unpivoted row is "deleted".
An optional parameter 'keep null rows' should provide the choice.
Now we have to do a workaround using eg. a Table.ReplaceValue with a dummy value.