I've tried it with your test data. It worked for me.
Did you use the UI or dev console? The UI has indeed a problem to show the preview.
To run a preview in dev console:
POST _transform/_preview
{
"source": {
"index": "YOUR_INDEX"
},
"pivot": {
...