Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

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&nameConflict={nameConflictResolution}&skipReport=false

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-585f1531f7c8/$metadata#imports/$entity","id":"770e2fd0-5842-4665-a409-41edc87e7d16","importState":"Failed","createdDateTime":"2020-06-13T06:05:06.793Z","updatedDateTime":"2020-06-13T06:05:06.793Z","error":{
    "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
Dataflow
Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        CatalinC3PO
        New Member
        5 years ago

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

  • powerbi_jenhen's avatar
    powerbi_jenhen
    Resolver II
    2 years ago

    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"