Joining dataset is not allowed due to capacity[High Priority]

Both of the dataset are coming from SQL queries, the issue is i dont want to make any changes on the query itself because it will affect other dashboards. I want to create a new dataset which contains both both dataset and use them to create a combined view.