hi raja,
I am the admin of the adobe account, it seems not a permission issue.
But you did give me a direction to troubleshoot.
It is only my VRS having issue pulling the data from DW, but seems if I change to a normal report suite, I am able to make the request.
so thanks for your help.