Dynamic CRM to Microsoft Fabric connection

[ivamsikrishna]

Hi Team, 

We are trying to create a connection to Dynamics 365 (Dataverse) in Microsoft Fabric. I try to look for reference document but all I find is related to Power Apps and Power Bi but not the Microsoft Fabric. When I try to create new connection selecting cloud option it is keep throwing error OAuth 2.0 is 'Failed to update cloud OAuth credentials from client secret'. 

Q1 - Is it required to create App service to connect to Dynamics 365 (Dataverse) and 

Q2 - Is there any support documents with detailed steps how to configure new connection to connect to Dynamics 365 (Dataverse) to work with crm data.

Appreciate,

Krishna

[rajendraongole1]

Hi @ivamsikrishna -can you please check the following threads:

Set up your OData connection - Microsoft Fabric | Microsoft Learn

Solved: Re: Issue with OAuth 2.0 authentication - Microsoft Fabric Community

Re: Connecting with Dynamics 365 Business Central ... - Microsoft Fabric Community

How to Set Up an Integration with Dynamics 365 Using OAuth - CRM Software Blog | Dynamics 365

Q2: 

Link all Dynamics 365 data to Microsoft Fabric | Microsoft Learn

Fabric Link for Dataverse: Initial Setup and Considerations (serverlesssql.com)

Hope this helps.

[ivamsikrishna]

thanks for sharing the reference links, majority of the links projecting how to connect in Power Apps but not specifying Dataverse (Dynamics CRM/365), especially using service principle related. Our main requirement was to create a link to Dynamics CRM/365 and leverage that connection in Copy activity (source and sync) for read and write operations. 

Appreciate