At the heart of Sola Scriptura, is the recognition that fallen humans are always looking to replace God’s authority with some other human/creaturely authority
We’re beggars because the words of man will never fill our spiritual appetite. We need food from heaven. We need to hear from God.
If dreams are valid today, they must be coupled with gospel proclamation. Any replacement of the gospel with dreams undermines the very economy of salvation God has revealed in Scripture.
The answer requires nuance, a full look at Scripture, and especially attention to the changes between the old covenant and the new.