Error using REST API to deploy/import dataflow using Service Principal

[Anonymous]

I am trying to import/deploy a dataflow using the REST API.

https://api.powerbi.com/v1.0/myorg/groups/{groupid}/imports?datasetDisplayName=model.json&nameConfli...

Documentation: https://docs.microsoft.com/en-us/rest/api/power-bi/imports/postimportingroup

The error I get is this:

{
  "@odata.context":"http://wabi-west-us-redirect.analysis.windows.net/v1.0/myorg/groups/ecf0a3e1-ff60-44ab-a33f-585f1531...":{
    "code":"DataflowUnauthorizedError","details":[]
  },"name":"RRao1 - Test - CRM Account Option Sets","connectionType":"import","source":"Upload","datasets":[],"reports":[]
}

I have tested the same code to deploy PBIX and that works. So, the SPN does have access to PowerBi and the ability to publish some files. I am just not sure why I am getting the DataflowUnauthorizedError. Other commands against dataflows (get, etc) all work.

Here is the error I get when I run it using PowerShell: The remote server returned an error: (401) Unauthorized.

TIA

[powerbi_jenhen]

Did you ever get this to work as I'm in the exact same boat as you? Looks like the only artefact type a service principal cannot deploy is a dataflow for some mad reason. I receive the error: "ALM_InvalidRequest_ServicePrincipalNotSupported"

[Anonymous]

HI @Anonymous,

So you mean direct upload to import data flow works, but rest API failed? If this is a case, did other rest API works on your account? I'd like to suggest you check your azure account and related permission and setting to confirm if you have the permissions to use rest API.
Regards,
Xiaoxin Sheng

[Anonymous]

Using the exact same api and the spn, upload is successful with a pbix file.

Using the same api and my login, upload of dataflow is successful.

Using the spn and the same api, the upload fails with a dataflow.

I have checked to make sure dataflow read write all has been set on spn via azure portal.

[CatalinC3PO]

Hey @Anonymous - were you able to figure this one out ? I get the exact same behaviour.

[lbendlin]

Did you follow these instructions?

Required scope: Dataset.ReadWrite.All
To set the permissions scope, see https://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app.

[Anonymous]

Yes!