topic Re: ADF Rest API Using Service Principal in Pipelines

ADF Rest API Using Service Principal

bcdobbs — Fri, 09 Jun 2023 03:19:32 GMT

Hi,

I'm trying to use a copy data activity in Fabric Data Pipeline to get data from MS Graph API. Just trying to recreate a small pipeline I have working currently in Azure.

It looks like I should be able to connect using a service principal but I can't make it work:

Wondered if anyone had any luck or pointers! Wondered if it was because there's no where to specify the AAD resource like there is when you set up a linked service in Azure:

I get the same if I try https://api.powerbi.com

Re: ADF Rest API Using Service Principal

GraceGu — Wed, 07 Jun 2023 09:51:19 GMT

REST connector does not support service principal authentication yet. You can check the auth type supported in connector REST connector overview - Microsoft Fabric | Microsoft Learn.

It is in roadmap. While it will be also helpful if you can submit an idea to prioritize.

Thanks

Re: ADF Rest API Using Service Principal

bcdobbs — Wed, 07 Jun 2023 09:36:13 GMT

Hi GraceGu,

I thought it may have become available. At launch the option wasn't there but earlier this week the following appeared:

Which makes it at least look like it's supported.

Re: ADF Rest API Using Service Principal

GraceGu — Wed, 07 Jun 2023 10:16:34 GMT

You are correct. It should be supported now, but not updated in doc.

Re: ADF Rest API Using Service Principal

bcdobbs — Wed, 07 Jun 2023 11:19:11 GMT

Are you able to check your end if they believe it's fully working? (Struggling to make it do what I think should do.)

Re: ADF Rest API Using Service Principal

GraceGu — Wed, 07 Jun 2023 11:47:04 GMT

Yes, I am checking

Re: ADF Rest API Using Service Principal

dtjdtj — Tue, 27 Jun 2023 13:49:46 GMT

Hi,

But if we access the documentation link you provided, it mentions service principal as supported capability:

Supported capabilities Gateway Authentication

Copy activity (source/destination)

None

Anonymous
Basic
Service principal

Still, it doen't work. Can you confirm, is the documentation wrong?

Thanks!

Re: ADF Rest API Using Service Principal

GraceGu — Wed, 28 Jun 2023 00:46:14 GMT

Thanks for the feedback. Service principal should be supported, but there is issue. Will share update on this.