topic Re: Power BI API Selective Deploy Dataflow via Service Principal in Developer

Power BI API Selective Deploy Dataflow via Service Principal

powerbi_jenhen — Wed, 04 Oct 2023 20:47:48 GMT

Hi,

I am currently successfully deploying Power BI reports, datasets, dashboards and paginated reports via the Power BI API Selective Deploy end points within a DevOps pipeline, I authenticate via Service Principal. However, when I attempt to deploy a dataflow I receive "ALM_InvalidRequest_ServicePrincipalNotSupported", is this correct, a service principal can deploy all artefact types except dataflows?

I'm using the same code as for reports and datasets etc but obviously tweeked for dataflows as microsoft details:

$body = @{

sourceStageOrder = $stageOrder

dataflows = @(

@{sourceId = $dataflowArtifactId }

)

options = @{

allowCreateArtifact = $TRUE

allowOverwriteArtifact = $TRUE

}

} | ConvertTo-Json

$deployResult = Invoke-PowerBIRestMethod -Url $url -Method Post -Body $body | ConvertFrom-Json

Re: Power BI API Selective Deploy Dataflow via Service Principal

powerbi_jenhen — Wed, 07 Feb 2024 14:50:07 GMT

Can anyone advise? This still seems to be an issue??????

Thanks.

Re: Power BI API Selective Deploy Dataflow via Service Principal

lbendlin — Thu, 08 Feb 2024 01:28:17 GMT

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Re: Power BI API Selective Deploy Dataflow via Service Principal

powerbi_jenhen — Thu, 08 Feb 2024 09:29:27 GMT

Thanks Ibendlin,

Are you also of the opinion that this should be a working API call? There's nothing obvious that I'm doing wrong?

Thanks.

Re: Power BI API Selective Deploy Dataflow via Service Principal

lbendlin — Thu, 08 Feb 2024 12:09:14 GMT

The whole CI/CD space is still in its infancy, might as well influence it according to how you think it should work.