How to connect Dataverse tables from ADF?

Question

We have a Dataverse table that we need to access via ADF. Following the process of user access amnaged identity we have created the managed identity, registered the app in Azure, Gave the access in Dataverse and then used the same in ADF Linked service. The test connection comesout fine however it doesnt recognise any table and it fails with the below error message: 'The HTTP request was forbidden with client authentication scheme 'Anonymous'. The remote server returned an error: (403) Forbidden. Activity ID: b0fffcad-4092-4dbb-b433-ddda71035997'

Please help us with the connectivity. Happy to connect over in calls.

Answer 1

Hi @Sowmya Pantula
Welcome to Microsoft Q&A platform and thanks for posting your query here.

Could you please confirm what authentication type is being used in your linked service?

I suspect something wrong with your authentication settings/configurations.

1. If you are using Azure AD service-principal authentication, you must set up server-to-server (S2S) authentication in Dataverse or Dynamics. First register the application user (Service Principal) in Azure Active Directory. You can find out how to do this here. During application registration you will need to create that user in Dataverse or Dynamics and grant permissions. Those permissions can either be granted directly or indirectly by adding the application user to a team which has been granted permissions in Dataverse or Dynamics. You can find more information on how to set up an application user to authenticate with Dataverse here.
2. In case if you are using Office 365 Authentication type, please note if your tenant and user is configured in Azure Active Directory for conditional access and/or Multi-Factor Authentication is required, you will not be able to use `Office 365 Authentication type. For those situations, you must use an Azure Active Directory (Azure AD) service principal authentication.

To further troubleshoot the issue, you can verify that the request is being sent to the correct API endpoint and that any necessary firewall rules are configured. Tools like Postman or Fiddler can help trace and diagnose the HTTP request to identify misconfigurations.

I would recommend reviewing the prerequisites section from the connector documentations: ADF Dynamics 365 connector - Prerequisites

Helpful document: This article will show step-by-step information about creating an application user: Manage application users in the Power Platform admin center

Hope this will help. Please let us know if any further queries.

---

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.