Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0

Power BI API Selective Deploy Dataflow via Service Principal

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? My service principal app has the correct API permission: Dataflow.ReadWrite.All

 

I'm using the same code for reports and datasets etc but obviously tweaked 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

Status: Delivered

Hi @powerbi_jenhen ,

 

To my knowledge the Power BI REST API does not support the deployment of dataflows with a service principal. This limitation might be the reason you’re encountering the“ALM_InvalidRequest_ServicePrincipalNotSupported” error.

Embed Power BI content in an embedded analytics application with service principal and an applicatio...

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

Hi @powerbi_jenhen ,

 

To my knowledge the Power BI REST API does not support the deployment of dataflows with a service principal. This limitation might be the reason you’re encountering the“ALM_InvalidRequest_ServicePrincipalNotSupported” error.

Embed Power BI content in an embedded analytics application with service principal and an applicatio...

 

Best regards.
Community Support Team_Caitlyn