In many project scenarios, a Power BI report will initially be built against a development or testing dataset. After this report has been validated or received the proper approvals, the report's source dataset can be switched to a production dataset and the report can then be published to the production app workspace used for distributing Power BI content to users.
To switch the Power BI dataset of a Live connection report, click the Data Source settings icon under the Edit Queries drop-down menu under the Home tab. In the following two steps with supporting images, a report is switched from a dataset in the Corporate Sales workspace to a dataset in the North America Sales workspace:
- Open the Power BI service data ...