Power BI deployment pipeline Azure DevOps Dataflow

[Charline_74]

Hello

Is it possible to deploy a dataflow with an Azure DevOps pipeline ?

Just for information I'm using a Service Principal to run the pipeline. 

Thanks in Advance, 

Charline

[v-shex-msft · Accepted solution]

Hi @Charline_74,

You can take a look at the following link about azure DevOps to invoke rest API, then you can refer them to use azure DevOps to integrate power bi rest API.

Invoke HTTP REST API task - Azure Pipelines | Microsoft Learn

Dataflows - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Notice: 

current power bi seems not support to use API directly create a dataflow, so I think you may need to create it at first, and then you can use API to modify them.

Regards,

Xiaoxin Sheng

[Daryl-Lynch-Bzy]

Hi @Charline_74 - you can you the import api to upload the dataflow json. Imports - Post Import In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn.  The irony is that you need to use Power BI to create the json file.

@v-shex-msft 

[carolpz]

Hello, @Charline_74. Did you find a solution for deploying dataflow with Devops?

@v-shex-msft is there a way to move the dataflow from a workspace to another using APIs? I only see APIs to change, but not to deploy (even by power bi Deployment pipelines).

I'm looking for a solution to dataflow deployment, but I couldn't find a way to automate this. 

Thank you in advance.

Carol

[Charline_74 · Accepted solution]

hello @carolpz, 

The solution I found is to use a Service Account + The deployment task of the Power BI Automation Tools extension

[michaelconan]

Looks like an interesting tool but it lists in the limitations that it cannot be used to deploy dataflows with a service principal.

[v-shex-msft · Accepted solution]

Hi @Charline_74,

You can take a look at the following link about azure DevOps to invoke rest API, then you can refer them to use azure DevOps to integrate power bi rest API.

Invoke HTTP REST API task - Azure Pipelines | Microsoft Learn

Dataflows - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Notice: 

current power bi seems not support to use API directly create a dataflow, so I think you may need to create it at first, and then you can use API to modify them.

Regards,

Xiaoxin Sheng