topic Re: Help Appreciated! Need assistance with Pipeline calls using REST API in Developer

Help Appreciated! Need assistance with Pipeline calls using REST API

arpost — Fri, 07 Oct 2022 16:39:49 GMT

Howdy, PBI Community! I am trying to set up a Power Automate custom connector to use for Rest APIs and can successfully run API calls like Get Dataflows with my current setup, but I always get a 401 error when trying to use the Pipeline APIs. About ready to pull my hair out and hope someone can help me. 😃

I'm trying to use the Get Pipeline and Get Pipeline Operations calls.

Here's the configuration in Azure:

Here's the custom connector configuration:

Re: Help Appreciated! Need assistance with Pipeline calls using REST API

lbendlin — Sun, 09 Oct 2022 01:22:48 GMT

Can you successfully run some of the more mature calls like workspaces? The Pipeline calls are very new and likely stilll buggy.

Re: Help Appreciated! Need assistance with Pipeline calls using REST API

arpost — Mon, 10 Oct 2022 16:16:57 GMT

Good question. I can use some of the other calls, so I guess the next question would be: has anyone successfully used the Get Pipeline call with an app registration?

Re: Help Appreciated! Need assistance with Pipeline calls using REST API

Watsky — Tue, 18 Oct 2022 19:20:06 GMT

Hey arpost ,

I can see deployment pipelines

What happens if you use the Try It button on the Get Pipelines page?

Are you using a service account?

What happens when you try doing the Admin version?

GET https://api.powerbi.com/v1.0/myorg/admin/pipelines

Admin - Pipelines GetPipelinesAsAdmin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Re: Help Appreciated! Need assistance with Pipeline calls using REST API

arpost — Tue, 01 Nov 2022 13:27:35 GMT

Thanks for the reply, Watsky! Good question. I am also getting a 401 when trying to use the Admin API you linked. Anything pertaining to pipelines fail for me despite the fact that I am an admin.

When I use the Try it! feature, I get a response as expected, which suggests to me there's a problem with the app registration in Azure. But I can't figure out what it would be since (1) other API calls using that app reg. work just fine (e.g., Get Groups, Get Dataflows) and (2) I have enabled all permissions pertaining to Pipelines (except Deploy) as instructed by MS doc.

Very frustrating!

Re: Help Appreciated! Need assistance with Pipeline calls using REST API

lbendlin — Tue, 01 Nov 2022 13:34:05 GMT

Check your auth token with jwt.io - might be a missing scope.

Re: Help Appreciated! Need assistance with Pipeline calls using REST API

arpost — Tue, 01 Nov 2022 14:07:49 GMT

Thanks for the reply, lbendlin. With MS custom connectors, they manage the tokens; I just provide some of the details for the app reg; the scope I am using is openid.

Re: Help Appreciated! Need assistance with Pipeline calls using REST API

lbendlin — Tue, 01 Nov 2022 14:24:53 GMT

You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

Re: Help Appreciated! Need assistance with Pipeline calls using REST API

greekgod — Tue, 21 Feb 2023 22:10:36 GMT

Hi Watsky, how are you pulling all pipeline operations using the PBI template, I use SPN which has admin privileges, but API is failing with pipeline access denied error.

Thanks,

Mahi