Azure Synapse Link for dataverse to bring Dynamics 365 data to ADLS and Synapse for analytical purpose - Facing Issues and inconsistencies in the feature
We are using Synapse Link for Dataverse feature to bring dynamics 365 data to ADLS and Synapse Analytics. We have below open issues due to which we are unable to finalize the solution:
1. In F&O linked dataverse environment, we have created a synapse link where in managed tables, all the F&O tables are not showing up (we have followed all the pre-requisites as per the MS documents and using [?athena.enableFnOTables=true] once the synapse link is created to view F&O tables).
2. As we have more than 1000 tables as per MS documents to activate more than 1000 tables we need to create new synapse link, so we tried creating new synapse link in same dataverse environment and getting the error - “Folder’s container endpoint and path or security group match with an existing folder.” 3. We are getting error while activating the available tables in synapse link “ An internal error occured, the profile is in Error state”. These are the major 3 open issues for which we are unable to get the solution and right direction, which is stopping us to take the decision of using azure synapse link for dataverse as an final solution for bringing data from the dynamics platform.
Please suggest clear steps to make available all the tables of dynamics 365 f&o and CRM in synapse link, as we are not able to get the exact tables and lots of them are missing from the list.
119
