PowerBI Clone Reports with Datasets and change DataSource Info

[stavros_koureas]

The requirement is to be able to clone reports (direct query) and the datasets (with same schema) and be able to change the connection information.

This way we can have a central PowerBI predefined "Release Workspace" for standard reports and programmatically clone those reports to "Customer Workspaces" and at the same time change the connection info to point into the Customer Database (of course same database schema will be the prerequisite).

Currently there are plenty of options for copying a report by using the PowerBI API or PowerBI Client SDK like the following:

1. pbiClient.Reports.CloneReportInGroup() to clone the report but not the dataset as this creates a new shared dataset with same datasource
2. pbiClient.Reports.RebindReportInGroup() to bind the cloned report into another dataset, but the standard dataset cannot be created pragmatically
3. pbiClient.Datasets.UpdateDatasourcesInGroup() if another dataset was existed there is no way to change the database information to point somewhere else

Non of these ways are able to copy the dataset or even to change the connection info from a Release Workspace to the target Customer Workspace!