web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Help with Azure Data F...
Power Apps
Answered

Help with Azure Data Factory and CDS

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hey all,

I'm trying to setup a data connector in Azure Data Factory to our Common Data Service. I'm getting pretty seriously hung up on authentication unfortunately. I've been following the instructions outlined in this doc for the ADF setup and this doc for auth, but I'm getting the following error message when testing the CDS service connection in ADF:

Unable to Login to Dynamics CRM: Invalid Login Information : The HTTP request was forbidden with client authentication scheme 'Anonymous'. The HTTP request was forbidden with client authentication scheme 'Anonymous'. => The remote server returned an error: (403) Forbidden.Unable to Login to Dynamics CRM Unable to Login to Dynamics CRM The creator of this fault did not specify a Reason.

I've setup the app registration in Azure AD, setup the application user in Dynamics associated to that app, and I'm definitely using the correct service principal ID and key from the app registration. Still I'm just getting the 403 complaining about anonymous auth.

I'm using the 'Common Data Service for Apps' linked service template, but I notice there are also templates for Dynamics 365, Dynamics AX, Dynamics CRM, and a generic ODATA connector. Maybe should I be using one of those instead?

Any advice is appreciated, thanks in advance.

I have the same question (0)
  • trese8 Profile Picture
    Microsoft Employee on at

    I would suggest to open a support case with Microsoft team.

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Reached out to our AD admin and spent about a half our debugging this. Got it working after giving our app user the sys admin role in Dynamics. I'm guessing this was a user permission issue. I don't feel very good about leaving the user with that role, but I can at least get ADF working while I continue to tweak permissions.

  • JF2022 Profile Picture
    10 on at

    When you say application user can I get some detail on what that means? I am getting the same error. If using Service Principal ID as the connection, what application user needs to be added to Dynamics platform?

  • JF2022 Profile Picture
    10 on at

    I have resolved this question. Thank you for the forum and answers.

  • ZimDE Profile Picture
    14 on at

    @JF2022  can you share your solution? I am getting the same error...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 834

#2
Valantis Profile Picture

Valantis 533

#3
Haque Profile Picture

Haque 410

Last 30 days Overall leaderboard