Changing Row Keys into Normal Rows

Question

I have a dataset with column and row keys:

dsA={<|"keyA" -> <|"key1" -> "a", "key2" -> "b"|>, 
  "keyB" -> <|"key1" -> "c", 
    "key2" -> "d"|>|>, <|"keyC" -> <|"key1" -> "a", "key2" -> "b"|>, 
  "keyB" -> <|"key1" -> "d", "key2" -> "f"|>|>}//Dataset

Because the row keys get in the way of a number of operations (such as joining with other datasets that might have a different number of rows), I want to change the dataset to the following form:

I asked this as an addendum to a different question, but so far no luck. I can create datasets of the values and the keys:

dsValues = dsA[Values]
dsKeys = dsA[Keys]

But I'm not sure how to put the dsKeys column in front of the dsValues table.

Answer 1

Map[KeyValueMap[<|"RowKeys" -> #, #2|>&]] @ dsA 

Also

dsA[All, KeyValueMap[<|"RowKeys" -> #, #2|>&]]

same result

Answer 2

Like this:

dsA[Flatten, KeyValueMap[Prepend[#2, "keys" -> #] &]]

?

Answer 3

Thanks to @kglr and @Kuba for their correct answers--I post this longer response to highlight an issue with brackets in datasets that I wasn't aware of. Apparently, you can make datasets in a couple of different ways--with a leading { bracket or without. Let's say we have two datasets (slightly modified versions of the one from my original question):

dsBracket = {<|
    "keyA" -> <|"key1" -> "a", "key2" -> "b"|>, 
    "keyB" -> <|"key1" -> "c", "key2" -> "d"|>,
    "keyC" -> <|"key1" -> "a", "key2" -> "b"|>, 
    "keyD" -> <|"key1" -> "d", "key2" -> "f"|>|>} // Dataset

and

dsNoBracket = <|
   "keyA" -> <|"key1" -> "a", "key2" -> "b"|>, 
   "keyB" -> <|"key1" -> "c", "key2" -> "d"|>,
   "keyC" -> <|"key1" -> "a", "key2" -> "b"|>, 
   "keyD" -> <|"key1" -> "d", "key2" -> "f"|>|> // Dataset

Note that the only difference is the {} on dsBracket.

I didn't realize that my dataset was lacking that bracket because I imported data and manipulated it all within the dataset environment--I'd prefer to ignore the mess! The datasets SemanticImport with the {; the dataset first loses the curly brace when I SelectFirst the result of a GroupBy.

@Kuba's method works for dsBracket, but produces a failure for the dsNoBracket. With @kglr's answer, I realized something weird was happening. Here's what happens with and without the bracket (and my workaround for the issue):