Way to create one data warehouse for all reports

Hi,
I'm looking for a way to create one data warehouse for all reports.

First I create a report with the name DW without visual effects. The role of this report is to be a data warehouse.

Then I create report with live connection to power bi service for using dataset DW.

Then I can create a second report on the DW data set and so on. Therefore, all my reports use the same set of data.

The problem occurs when I want to publish a report to a different workscpace than a dataset located. I expected that I could just publish the data set to the desired workspace and then publish the report there. But this is impossible. There is no possibility to choose a workspace. Are there ways to solve this problem?

My main goal is to have one set of data (data warehouse) for all reports.