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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
arpost
Kudo Collector
Kudo Collector

Help Appreciated! Need assistance with Pipeline calls using REST API

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.

 

arpost_1-1665149982642.png

 

Here's the configuration in Azure:

 

arpost_0-1665149099061.png

 

Here's the custom connector configuration:

 

arpost_0-1665149815195.png

 

8 REPLIES 8
lbendlin
Super User
Super User

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

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?

Hey @arpost ,

I can see deployment pipelines 

Watsky_0-1666106677324.png

Watsky_1-1666106844197.png

 

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

 

Watsky_2-1666106875424.png

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


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up!
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

Proud to be a Super User!

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

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.

 

arpost_0-1667309161992.png

 

Very frustrating!

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

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.

 

arpost_0-1667311646102.png

 

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/

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.