API Changing the data source of a dataflow

[Charline_74]

I would like to know if it is possible to change the data source of a dataflow with an API.

For example:

I have a pipeline in which I have a workspace of DEV, TEST and PROD.

And I would like that when I deploy the dataflow on the different environments the data source of the dataflow changes too.

For info I use gataway in my dataflow

[Charline_74 · Accepted solution]

I have found out how to do this and here is the script:

$groupId = ""

 

$dataflowId = ""

 

$dataflowUpdate = "{
    'name' : 'Updated Dataflow Name',
    'description' : 'This is the updated dataflow description'
}"

 


$url = "groups/$groupId/dataflows/$dataflowId"

 

Invoke-powerBIRestMethod -Method Patch -Url $url -Body $dataflowUpdate -ContentType "application/json"

[Anonymous]

Hi @Charline_74,

I check on the power bi rest API document but not found any Dataflow API suitable to your requirement. Perhaps you can submit an idea for adding support to use rest API change the dataflow data sources.

Microsoft Power BI ideas
Regards,

Xiaoxin Sheng