Hi @Bhavin Patel ,
Usually we are advised to use workarounds like SQL Server linked servers or SSIS which uses non SSRS datasources to extract data to be joined or SSRS lookup functions to achieve desired result outside of the report data retrieval stage.
We often consider the task of how to include data from disparate data sources in SSRS reports without having to look up functions, code, SSIS, or linked servers. The following links provide more possibilities: SSRS: Join data from different SSRS data sources into data set.
Link 1: SSRS: Merge data from different datasources into one dataset inside SSRS report.
Link 2: SSRS: Merge data from different data sources into one data set inside SSRS report using XML Connection.
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.