Power BI API Selective Deploy Dataflow via Service Principal

Question

Hi,&nbsp;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?&nbsp;I'm using the same code as for reports and datasets etc but obviously tweeked for dataflows as microsoft details:&nbsp;$body = @{ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sourceStageOrder = $stageOrder&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dataflows = @(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @{sourceId = $dataflowArtifactId }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; options = @{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; allowCreateArtifact = $TRUE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; allowOverwriteArtifact = $TRUE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } | ConvertTo-Json&nbsp; &nbsp; &nbsp; &nbsp; $deployResult = Invoke-PowerBIRestMethod -Url $url -Method Post -Body $body | ConvertFrom-Json

powerbi_jenhen · Answer

Can anyone advise? This still seems to be an issue??????&nbsp;Thanks.

lbendlin · Answer

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 .

powerbi_jenhen · Answer

Thanks Ibendlin,&nbsp;Are you also of the opinion that this should be a working API call? There's nothing obvious that I'm doing wrong?&nbsp;Thanks.

lbendlin · Answer

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

Forum Discussion

Power BI API Selective Deploy Dataflow via Service Principal

4 Replies

Related content

Service Principal account connection between Dataflow Gen2 and Lakehouse

Dataflow selecting destination

dataflow gen1

Fabric Dataflow Gen 2

Powerbi MCP via service principal