Solved: API Changing the data source of a dataflow

Charline_74 · ‎01-05-2023

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 · ‎01-11-2023

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"

View solution in original post

Charline_74 · ‎01-11-2023

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 · ‎01-05-2023

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