topic Re: API Changing the data source of a dataflow in Developer

API Changing the data source of a dataflow

Charline_74 — Thu, 05 Jan 2023 08:14:42 GMT

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

Re: API Changing the data source of a dataflow

Anonymous — Fri, 06 Jan 2023 02:42:35 GMT

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

Re: API Changing the data source of a dataflow

Charline_74 — Wed, 11 Jan 2023 10:56:33 GMT

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"