topic Problem in cloning data set from one workspace to other. in Developer

Cloning the data sets of Power BI with connection to the different database using API.

Anonymous — Sun, 06 Jan 2019 15:08:18 GMT

I want to clone the datasets of Power BI with the connection to the different database by using API.

I'm able to create the data set by giving the hardcoded data to the "tables" property.

"tables": [ { "name": "Product", "columns": [ { "name": "ProductID", "dataType": "Int64" }, { "name": "Name", "dataType": "string" }, { "name": "Category", "dataType": "string" }, { "name": "IsCompete", "dataType": "bool" }, { "name": "ManufacturedOn", "dataType": "DateTime" } ].

But I want to clone the datasets that are already there in another workspace with the different database connection.

But the problem it is saying is, we can only clone the datasets that are created by using the API.So that it can have API access. We cannot clone the datasets that are published in PowerBi Desktop.

My requirement is to clone the datasets of another workspace with the different database connection.

Please help me solve this. Thanks.

Problem in cloning data set from one workspace to other.

Anonymous — Sun, 06 Jan 2019 12:32:54 GMT

Is it possible with PowerBI API to get columns of a table with all the fields and data type?

e.g. with the GET "htps://api/powerbi.com/v1.0/myorg/datasets/ID/tables" I get the JSON that looks something like this
"value":[{ "name": "product"}], but what I really need is JSON that contains table name but also all the columns fields with the corresponding data type.

How to make this?

Cloning a dataset from one workspace to another workspace using powerbi API

Anonymous — Sun, 06 Jan 2019 12:41:00 GMT

I am trying to clone the complete Power BI report. With API, reports can be cloned but the datasets are not cloned. How to clone the report with its dataset.

Re: Cloning a dataset from one workspace to another workspace using powerbi API

v-jiascu-msft — Wed, 09 Jan 2019 09:33:13 GMT

Hi @Anonymous,

Though we can't clone the dataset directly, there could be a workaround. The change is only the data source.

1. Upload the pbix file with imports/postimportingroup.

2. Update the data sources with datasets/updatedatasourcesingroup.

Please also note there are some limitations.

Best Regards,
Dale

Re: Cloning a dataset from one workspace to another workspace using powerbi API

koureass — Fri, 13 Jan 2023 14:16:45 GMT

I think is not possible to change the database, currently i am using the method datasets/updatedatasourcesingroup, for postgressql database.

The message I get is always "Not Found" because this function needs a gateway, in that case the reports are running without a gatway as the source database is located in azure.

Any idea on this schenario?