How to change Power BI live connection data source in power BI service with another live connection

[Anonymous]

Hi,

If a power BI dataset is connected Live to a report, In Power BI desktop we can change that datasource connection to other data source connection live connection with same data structure. But same feature is not available in power BI service. Please let me know if if is available.

For Example:

power BI dataset 'X_dev' is connected to report 'Y', I want to change data source in Y to  power BI dataset 'X_uat' or 'X_prod'. Currently i need to do this desktop manually. Is this feature available in Power BI service ? Is it Possible with power BI rest API ?

Thanks & Regards,

Mani 

[Anonymous]

I would recommend you to take a look at the topic update data source using Power BI rest API

[Anonymous]

Hi,

I am looking for some solution using Power BI rest API. but I don't see power BI data set as supported data source.

[Anonymous]

I would recommend to take a look at the following aricle

Datasets - Update Datasource using Power BI Rest API 

Use the following picece of code in JSON Body field

    {
    "updateDetails": [
      {
        "datasourceSelector": {
          "datasourceType": "AnalysisServices",
          "connectionDetails": {
            "server": "DATA SOURCE IN CURRENT REPORT",
            "database": "CUBE NAME IN CURRENT REPORT"
          }
        },
        "connectionDetails": {
          "server": "TARGET SERVER NAME",
          "database": "TARGET CUBE NAME"
        }
      }
    ]
  }

[Tad17]

Changing the data source has to be done in Power BI Desktop and then republished to the service. The only time you can mess with data sources anywhere else is through Power BI Premium.

[Anonymous]

Hi,

I am trying to automate  deployment  process using Azure Devops. So I need  to do it using REST API.