Yes, This is possible.
In order to connect 2 different databases of same server you can proceed with the below steps.
Step1: Select any single database and create metadata by selecting table & columns.
Step2: Once you are on the metadata page, go to “View” tab.
Step3: Create SQL view where define query contains joining conditions of both the databases which you want to connect.
Step4: Now, output of this view can be used at report level in order to connect to both of these databases.
If you have any more queries please get back us.