Another thing I asked. God replied, "At first you said, 'I asked one thing, to dwell in the house of God.' But then you said, 'To behold the beauty of God and to visit His sanctuary.' I say before you, Master of the Universe, that the servant should not be equal to his master. At first, you did not ask much of me, as it says, 'And now, Israel, what does the Lord your God ask of you, but to fear the Lord your God.' But then, you asked for many commandments, as it says, 'To walk in all His ways and to love Him.' Be content with being a servant, so that you may be like your master."...
David Asked One Thing of God and Got a Surprising Answer
Midrash Tehillim 27:5