Dynamics Community Forum Thread Details

Integrating Dynamics and SQL to build reports

Hi All,

I am trying desperately to integrate Dynamics into a SQL server, so I can include it in my data model (this model contains other data sources thats why I need the dynamics data in SQL).

I tried to set up a connection as a linked service in Azure Data Factory, and followed this process:

Registered an application in Azure AD for Dynamics CRM (PowerBi-Reporting_Dynamics-CRM)
Granted API permissions in Azure AD
For Dynamics CRM, Azure Key Vault, Data Export Service for Microsoft Dynamics 365 (As per the current Azure set up, we can only use user-impersonation)
Generated the client secret
Added this in Azure Key Vault using generated info
Added Dynamics CRM in Data Factory as a linked service, tried using different authentication methods (Office 365- password login and Key vault, Service Principal - Key, using ID and KEY from created application we registered)

But got this error:

Failed to connect to Dynamics: 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.

Is anyone able to support on this?

Thank you so much!

Quick Links

Leaderboard