Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Ability to Change the origin dataset connection for Live connected reports in service

We a scenario that we have a dev workspace which is used to build the reports pointing to dev dataset and than using CI/CD we deploy it to many target workspace, after the deployment we rebind all the reports in target workspace with dataset present in that workspace, this will fix the connection between the target report and target dataset, but if i try to download a report using live connection and open it via Power BI desktop, it will still point to old dev workspace, since the rebind will only change some connections in metadata(RemoteArtifact) of a report.

 

We need an ability to also change this connection(PbiModalDatabaseName).

Below is an example of the report metadata

{
  "Version": 2,
  "Connections": [
    {
      "Name": "EntityDataSource",
      "ConnectionString": "*****"
      "ConnectionType": "pbiServiceLive",
      "PbiServiceModelId": ******,
      "PbiModelVirtualServerName": "******",
      "PbiModelDatabaseName": "d*******3"
    }
  ],
  "RemoteArtifacts": [
    {
      "DatasetId": "f*******c",
      "ReportId": "1********6"
    }
  ],
  "OriginalWorkspaceObjectId": "9**********7"
}

 

Status: New