Report with live connection to a Dataset - Powershell & CICD - Modify the Dataset ID of the report

[Bamak]

Hi

For  CI-CD requirements , is there a way please via Powershell to change the dataset ID of a report (on live connection) ?

Process we would like to use : Deploy a report via the premium pipeline tool (or powershell) to TEST / PROD  workspaces environments

And just after modifying the dataset identifier (dev dataset -> test DS -> PROD DS)  via powershell

I know that currently it's not possible to modify the Datasetid of a live report through settings  on premium pipeline tool

Hope powershell (and api) can help us ? 

Thanks a lot for any informations 

Best regards

Christophe

[v-yiruan-msft · Accepted solution]

Hi @Bamak ,

Please review the content in the following links and check whether they are what you are looking for.

1. CICD using Azure DevOps

PowerBI - CICD using Azure DevOps

2. Use query parameter

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters

3. Rest API: Reports - Rebind Report In Group

How to Change Live Dataset and Overwrite the Existing Report

Best Regards