Forum Discussion

Charline_74's avatar
Charline_74
Resolver I
3 years ago
Solved

API Changing the data source of a dataflow

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

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Charline_74's avatar
    Charline_74
    3 years ago

    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"

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • Charline_74's avatar
    Charline_74
    Resolver I
    3 years ago

    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"